In part 1 of this series, we learned about the basics of indexes, what they do, and what they’re for. In part 2, we talked about query plans. We learned about reading query plans so that we could understand how SQL Server goes about retrieving the data we ask for. This is an important first step figuring out where to begin when implementing indexes. In this 3rd and final installment of our indexing series, we’re going to learn how to make and test indexes in SQL Server.
(more…)