|
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
Navigation:
[Reply to this message]
|