MS SQL Server Indexes Question:
Download Job Interview Questions and Answers PDF
Explain what is it unwise to create wide clustered index keys?
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 Question | Next Question |
Explain full-text indexing? | Explain the difference between clustered and non-clustered index? |