Forum Moderators: open
I use Sql server 2005, I know it will recalculate index as well as statistics when I update/delete/insert etc.
When it recalcuating, it need resources, mem and cpus etc. I have a period of time need massive update whole table, and I do not want it recalcuate while I am changing the table.
So I want to know, is there any sql can be used to pause the recalculate procedure, thanks.
