File Library

Optimizer Hints: Top Tips for Understanding and Using Them
Topic: The Database
Owner: Maria Colgan
Date: 2013-05-24
Subtopic: Tips and Techniques

The goal of the Oracle Optimizer is to examine all possible execution plans for a SQL statement and to pick the one with the lowest cost, which should be the most efficient. From time to time, it may become necessary to influence the plan the Optimizer chooses. The most powerful way to alter the plan chosen is via Optimizer hints. But knowing when and how to use Optimizer hints correctly is somewhat of a dark art. This session explains in detail how Optimizer hints are interpreted, when they should be used, and why they sometimes appear to be ignored. By attending this session people should walk away with the necessary knowledge to apply the right hints, in the right place, at the right time to get the most efficient execution plan.

Download File   MColgan.Optimizer_Hints.pdf

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