chandan_jha18 (12/27/2012)
Removing non clustered index does give me benefit of 40 min-1 hour but then when I create them it will compensate for the gain that I got:-)Thanks
Chandan
Yes, but you also have the gain of having an index with low fragmentation.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP