Database Partitioning Interview Question:

What are the Advantages of the database partitioning?

Submitted by: Administrator

Some 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