How to Think Like the SQL Server Engine Part 4
We finished part 3 with two similar-looking queries that produce very different behavior: one does a seek, and the other does a scan. Now you'll learn why, plus add yet another index to make this query go faster, and then discuss the drawbacks of too many indexes.