File Library

Oracle Optimizer: An Insider’s View of How it Works
Topic: Kscope13 Recordings
Owner: Maria Colgan
Date: 2013-06-26
Subtopic: The Database

The Oracle Optimizer is one of the most fascinating aspects of the Oracle Database. With each new release the Optimizer evolves as we strive for the holy grail of always finding the optimal execution plan for every SQL statement. Understanding how the Optimizer operates and what influences its choices helps you provide the necessary information to make that nirvana a reality. This session explains in detail, with easily reproduced examples, how the latest version of the Optimizer works and the best ways you can influence its decisions to ensure you get an optimal execution every time. It will explain how the Optimizer is slowly evolving to become self-learning and what you should expect when you upgrade to the next version.

Download File   MColgan_12c_optimizer.pdf
Download File   Rhythms I Session 15.mp4

Become a member of ODTUG to gain access to more than 12,500 files in our technical database.

  • Not a member? Click through to the topic of interest to browse a list of available presentations.
  • Already a member? Log-in here to access the full database

Click here to see the Full Techincal Resource Database