GilaMonster (2/16/2010)
muthukkumaran (2/16/2010)
Object have cluster index ?It's not required that a table have a clustered index in order to defragment a nonclustered index.
Yes I agreed Gail.
The OP create a Non clustered index,so i guess the table was Heap.
Muthukkumaran Kaliyamoorthy
https://www.sqlserverblogforum.com/