What are the Advantages of the database partitioning?
Submitted by: AdministratorSome of the advantages offered:
Partitions can be stored in different tablespaces.
Partitions can be added/ removed while users are working. DBAs can perform maintenance without having to bring down an entire table (import/ export/ load/ etc).
Data can be selected from targeted partitions without having to scan all partitions for rows (partition pruning). The SQL optimizer will bypass partitions that don't contain data pertinent to the query being solved.
Submitted by: Administrator
Partitions can be stored in different tablespaces.
Partitions can be added/ removed while users are working. DBAs can perform maintenance without having to bring down an entire table (import/ export/ load/ etc).
Data can be selected from targeted partitions without having to scan all partitions for rows (partition pruning). The SQL optimizer will bypass partitions that don't contain data pertinent to the query being solved.
Submitted by: Administrator
Read Online Database Partitioning Job Interview Questions And Answers
Top Database Partitioning Questions
| ☺ | Explain Partitioning types? |
| ☺ | How to enable partition support for a database? |
| ☺ | What is database partitioning? |
| ☺ | What are the Advantages of the database partitioning? |
Top Data Warehouse Job Categories
| ☺ | Warehouse Assistant Interview Questions. |
| ☺ | Ab Initio Interview Questions. |
| ☺ | Data Stage Interview Questions. |
| ☺ | ColdFusion Interview Questions. |
| ☺ | Data Warehouse Supervisor Interview Questions. |
