“Why isn’t my query using an index?” is a common question people have when tuning SQL.
This talk explores the factors that influence the optimizer’s decision behind this question. It introduces the concepts of blocks and the clustering factor. It discusses how these affect the optimizer's calculations. It goes on to show how these concepts work in practice using real SQL queries.
This session is intended for developers who want to learn how the optimizer works and how to make their SQL run quickly!