ScottPletcher (8/3/2014)
8 hours seems extraordinarily extreme for 172M rows. It seems like there must be more to the story.Are you changing the clustered index on the table? Does the table have other indexes?
hmm I never change anything before ..
yes the table has 5 other indexes...
atm the page count of that index is 788.162 and other indexes also have high page count ...
is that because of the large table or because of high page split ?