Welcome to jBasket Interviews, where you can ask questions and receive answers from other members about job interviews and job seeking tips.

What are clustered Indexes and nonclustered indexes

0 votes
asked 2 years ago by Kelly.Jackson (410 points)

1 Answer

0 votes
A clustered index stores the actual data rows at the leaf level of the index. An important characteristic of the clustered index is that the indexed values are sorted in either ascending or descending order. As a result, there can be only one clustered index on a table or view.

Unlike a clustered indexed, the leaf nodes of a nonclustered index contain only the values from the indexed columns and row locators that point to the actual data rows, rather than contain the data rows themselves. This means that the query engine must take an additional step in order to locate the actual data. Nonclustered indexes cannot be sorted like clustered indexes; however, you can create more than one nonclustered index per table or view.
answered 2 years ago by Kelly.Jackson (410 points)

Related questions

0 votes
1 answer
asked 2 years ago by Kelly.Jackson (410 points)
0 votes
1 answer