Posted by Utahduck on 05/02/07 14:41

In a message posted some time ago somebody had asked if there was a
maximum number of indexes. I don't know if that was answered or not
but I stumbled across the answer recently. The number is 250 on
either a table or a view. Only one can be clustered but on a table
you don't have to have a clustered index (you do on a view). If you
use a clustered index, you are left with 249 non-clustered indexes.

So, choose wisely. ;)

-Utah

[Back to original message]