MS SQL Server Indexes Question:

Download Job Interview Questions and Answers PDF

Explain what is it unwise to create wide clustered index keys?

SQL Server Indexes Interview Question
SQL Server Indexes Interview Question

Answer:

A clustered index is a good choice for searching over a range of values. After an indexed row is found, the remaining rows being adjacent to it can be found easily. However, using wide keys with clustered indexes is not wise because these keys are also used by the non-clustered indexes for look ups and are also stored in every non-clustered index leaf entry

Download SQL Server Indexes Interview Questions And Answers PDF

Previous QuestionNext Question
Explain full-text indexing?Explain the difference between clustered and non-clustered index?