>>Should have dropped the R and said CUD - create, update, delete operations
>>
>>Why wouldn't you just rebuild the indexes? What purpose does dropping them and re-adding them serve?
>>
>>Rebuilding indexes with the online option = no downtime:
>>
http://www.mssqltips.com/sqlservertip/2361/rebuilding-sql-server-indexes-using-the-online-option/>
>Rebuilding is not recommanded. I prefer to have it clean whenever I create one.
I have never heard of rebuilding indexes not being recommended. Do you have any good references to support that statement?
Brandon Harker
Sebae Data Solutions