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