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.
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