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 Understanding Optimizer Statistics with Oracle Database 12c, Part 1 (PDF) red-arrow-box Gathering and Publishing Statistics Independently(OBE)  
red-arrow-box Best Practices For Gathering Optimizer Statistics with Oracle Database 12c, Part 2 (PDF)
red-arrow-box Explain the Explain Plan (PDF)
red-arrow-box Upgrading from Oracle 10g to 11g:  What to Expect from the Optimizer (PDF)
red-arrow-box Upgrading from Oracle 9i to 10g:  What to Expect from the Optimizer (PDF)
red-arrow-box More...
Presentations & Webcasts
red-arrow-box The Oracle Optimizer - What to expect when you upgrade to Oracle Database 12c (Recording)
red-arrow-box The Oracle Optimizer - What to expect when you upgrade to Oracle Database 11g (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 11g - 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!
 

 

In-Memory Replay Banner