12c database logo Query Optimization
For over three decades, Oracle's Database technology has led the industry in performance and scalability. Oracle Database 12 c 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 Adaptive Query Optimization
The new groundbreaking adaptive query optimization in Oracle Database 12c enables the Optimizer to make runtime adjustments to execution plans and to discover additional information that can lead to better statistics. Learn about this exciting new functionality here.
Technical Information
Demo & How-To
red-arrow-box What to expect from the Optimizer with Oracle Database 12c(PDF)   red-arrow-box Controlling Execution Plan Evolution Using SQL Plan Management(OBE)
red-arrow-box SQL Plan Management with Oracle Database 12c (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 with Oracle Database 12c, Part 1 (PDF)
red-arrow-box Best Practices For Gathering Optimizer Statistics with Oracle Database 12c, 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