Databases Reference
In-Depth Information
Figure 7.1
Essential range partitioning.
Very briefly, the benefits of range partitioning include:
1.
Increased addressability allowing databases to store larger tables.
2.
Partition elimination, allowing the query compiler to select more efficient
query execution plans.
3.
Improved administration, allowing database administrators (DBAs) to perform
administration tasks on a subset of table data, including tasks like BACKUP,
LOAD, defragmentation, and reclustering.
4.
Fast roll-in and roll-out.
5.
Implicit data (input/ouput [I/O]) clustering
