ReamerXXVI (8/21/2014)
I need to reorg/rebuild the indexes on a large table (8.7 billion rows of data), should I rebuild the clustered index first or the non-clustered indexes first, or does it not matter?Thanks,
Gail answered the question that you asked.
To simplify and shorten such reindexing of this large table, have you considered either Paritioned Views or Partitioned Tables?
--Jeff Moden
Change is inevitable... Change for the better is not.