Last week I was lucky enough to have participated in the Trivadis Performance Days 2017 conference, and several people have asked if I would share the slides from one of my sessions. I’ve done one better by recording the session so you see the slides and listen to the explanation that goes along with them.
The session in question was “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.
In this session, I explained how Optimizer hints are interpreted, when and where they should be used, and why they sometimes appear to be ignored.
Be warned this session won’t make you a hinting master overnight, and I’m not advocating you should try and hint every problematic SQL statement you encounter!