May 2018
Intermediate to advanced
576 pages
30h 25m
English
This recipe explains what to do if you think your query should use an index, yet it does not.
There could be several reasons for this, but most often, the reason is that the optimizer believes that, based on the available distribution statistics, it is cheaper and faster to use a query plan that does not use that specific index.