Partitioning: Divide and Conquer
ŸFor manageability
ŸBreak large problems into manageable pieces ŸCan load / rebuild individual partitions ŸCan load / rebuild multiple partitions concurrently
ŸFor performance
ŸQuery parallelism
ŸPartition elimination
Ÿ
ŸTwo reasons for partitioning
ŸCan partition tables, or indexes, or both
–Also spatial indexes
ŸTransparent to applications!