1"There are two types of Indexes in SQL Server
2
31. Clustered Index
4
5A clustered index defines the order in which data
6is physically stored in a table. Table data can
7be sorted in only way, therefore, there can be only
8one clustered index per table. In SQL Server,
9the primary key constraint automatically creates a
10clustered index on that particular column.
11
122. Non-Clustered Index
13
14A non-clustered index doesn’t sort the physical
15data inside the table. In fact, a non-clustered
16index is stored at one place and table data is
17stored in another place. This is similar to a
18textbook where the book content is located in o
19ne place and the index is located in another.
20This allows for more than one non-clustered index per table."
21