10g database logo Query Optimization
For over three decades, Oracle's Database technology has led the industry in performance and scalability. Oracle Database 11 g builds on a powerful array of query optimization features that maximize performance and allow DBAs to become more productive by providing innovation in plan stability. Read on to know more about the latest Oracle Database query optimizations.
Highlighted Tips/Articles Technical Information Demos & How-To Presentations & Webcasts
Highlighted Tips/Articles
red-arrow-box How Do I know what Extended Statistics I need to create?
Extended statistics, help the Optimizer improve the accuracy of cardinality estimates for SQL statements that contain predicates involving a function wrapped column (e.g. UPPER(LastName)) or multiple columns from the same table used in filter predicates, join conditions, or group-by keys. So extended statistics are extremely useful but how do you know which extended statistics should be created? In Oracle Database 11.2.0.2 we introduced Auto Column Group Creation, which automatically determines which column groups are required for a table based on a given workload. Please note this functionality does not create extended statistics for function wrapped columns it is only for column groups. More information on how Auto Column Group Creation works can be found here.
Technical Information
Demo & How-To
red-arrow-box Upgrading from Oracle Database 10 g to 11 g: What to expect from the Optimizer (PDF)   red-arrow-box Controlling Execution Plan Evolution Using SQL Plan Management(OBE)
red-arrow-box SQL Plan Management in Oracle Database 11 g (PDF)
 		 red-arrow-box Using Extended Statistics to Optimize Multi-Column Relationships and Function Based Statistics(OBE)
red-arrow-box Oracle Optimizer: Explaining the Explain Plan (PDF)   red-arrow-box Gathering and Publishing Statistics Independently(OBE)  
red-arrow-box Understanding Optimizer Statistics, Part 1 (PDF)
red-arrow-box Best Practices For Gathering Optimizer Statistics, Part 2 (PDF)
red-arrow-box Upgrading from Oracle 9 i to 10 g:  What to Expect from the Optimizer (PDF)
red-arrow-box More...
Presentations & Webcasts
red-arrow-box The Optimizer - What to expect when you upgrade to Oracle Database 11 g (Recording)
red-arrow-box Best Practices for Managing Optimizer Statistics OOW 2011(Recording)
red-arrow-box The Oracle Database 11g Optimizer: Good things get even better (Recording)
red-arrow-box Best Practices for Managing Optimizer Statistics - Part 1 (Recording)
red-arrow-box Best Practices for Managing Optimizer Statistics - Part 2 (Recording)
red-arrow-box What to Expect from the Optimizer When Upgrading to Oracle Database 11 g - OpenWorld 2009 (PDF)
red-arrow-box Inside the Oracle Database 11 g Optimizer - OpenWorld 2008 (PDF)
red-arrow-box SQL Plan Management - OpenWorld 2007 (PDF)
 
Links
red-arrow-box Learn More: Optimizer Blog, Training, Library, Discussion Forum - Oracle Database, Data Warehouse Insider Blog, Data Mining Blog
red-arrow-box Related Technologies: Oracle BI Home, Oracle Exadata Storage Technology, Oracle Retail Data Model, Oracle Communications Data Model, Data Integration , Oracle OLAP, Oracle Data Mining, Oracle Statistical Functions, Oracle Information Lifecycle Management
red-arrow-box
BIWA - the Oracle BI, Data Warehousing and Analytics SIG. Join Today!
 

 
Left Curve
Popular Downloads
 Right Curve
Untitled Document
Left Curve
More Database Downloads
 Right Curve