An issue I often see folks missing when reviewing query plans, is that they
see that all of their scans involve indexes and they think that the query
is likely already as fast (or efficient) as it can be.

In this post we’ll look through several examples, some things to look out
for, and how to then go about making things faster.