File Library

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.