SQL Server stores data in tables and indexes. They represent a collection of data pages with rows that belong to a single entity or object.
By default, the data in tables is unsorted. You can store it in sorted order by defining a clustered index on the table. Moreover, you can create nonclustered indexes that persist another copy of the data from the index columns sorted in a different order.
In this chapter, we will talk about the internal structure of the indexes, cover how SQL Server uses them, and discuss how to write queries in a way that ...
