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”