Query Execution Improvements Related to Partitioned Tables

Enhancements to the optimizer improve execution times for queries against partitioned tables, especially queries used in data warehousing applications.

Query optimization involving partitioned tables previously included partition pruning against constant predicates, and partition-compatible joining. The enhancements include:

• More complete analysis of partition pruning opportunities
• Join-time partition pruning
• Nested partition-compatible joining
• Partition-compatible aggregation