How to use Oracle Optimizer Hints – Part 4 of the Optimizer Workshop

From time to time, it may become necessary to influence the plan the Optimizer chooses via Optimizer hints. This session explains how Optimizer hints are interpreted, when and where they should be used.

  • Version
  • Download 105
  • File Size 22.95 MB
  • File Count 1
  • Create Date October 13, 2020
  • Last Updated October 13, 2020

How to use Oracle Optimizer Hints - Part 4 of the Optimizer Workshop

Part 4 is called “Harnessing the power of optimizer hints”. Although I am not a strong supporter of adding hints to SQL statements for a whole host of reasons, 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 how Optimizer hints are interpreted, when and where they should be used, and why they sometimes appear to be ignored.

Leave a Reply

Your email address will not be published. Required fields are marked *