Benefits of Partioning (2)
Performance
–
The optimizer eliminates partitions
that not have to be scanned
–
Partitions can be scanned in parallel
–
Partitions can be load-balanced
across physical devices
–
Join operations can be optimized to
“
join by the partition
”