Partitioning tables for performance

Partitioning a table can improve performance for several types of processes. The reasons for partitioning a table are:

The tables you choose to partition depend on the performance issues you encounter and the performance goals for the queries on the tables.

The following sections explain the commands needed to partition tables and to maintain partitioned tables, and outline the steps for different situations.

See “Guidelines for parallel query configuration” for more information and examples of partitioning to meet specific performance goals.