Business Intelligence Features - Optimization Oracle Database 11g builds on a powerful array of query optimization features that maximize performance.
SQL Plan Management in Oracle Database 11g (PDF)
Describes the SQL Plan Management feature introduced in Oracle Database 11g Release 1 and covers functionality added in Oracle Database 11g Release 2. The feature ensures that no new query execution plan is used unless its performance has been verified as better than or comparable to the current plan.
DSS Performance in Oracle Database 10g Release 2 (PDF)
Oracle Database 10g Release 2 enables transparent performance enhancements for vital operations including sort and aggregation. Other enhancements improve performance with partitioned tables and for data mining. The paper benchmarks the new features against Oracle Database 10g Release 1.
Materialized Views in Oracle10g (PDF)
Materialized views are used to implement “summary tables” in a data warehouse and can vastly enhance query performance. This white paper describes materialized view functionality in detail.
DSS Performance in Oracle Database 10g Release 1 (PDF)
Oracle Database 10g Release 1 provides significant performance enhancements automatically, with no extra deployment costs or resource requirements. This paper measures performance gains from the new features used on a test database.