MS SQL Server Indexes Question:
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
| Previous Question | Next Question |
| Explain full-text indexing? | Explain the difference between clustered and non-clustered index? |