MS SQL Server Indexes Interview Question:

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

Submitted by: Administrator

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
Submitted by: Administrator