Tag: execution plan

  • SQL Server Indexing: Part 2 – Reading Query Plans

    SQL Server Indexing: Part 2 – Reading Query Plans

    Welcome to part 2 of SQL Server Indexing, in part 1, we learned the basics of indexes and the difference between clustered and non-clustered indexes. In this part, we’re going to learn how to read and interpret query plans, which will help us decide where to put indexes (or how to restructure our queries).