D. Features Introduced in Ingres 10.0 : DBMS Server Enhancements : Query Execution Improvements Related to Partitioned Tables
 
Share this page                  
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