For some performance issues I do Analyze the tables and Rebuild the indexes on a medium size database.
Some of the tables have 50 million+ rows.
I am wondering if it will Analyze the tables faster if I rebuild the indexes first or vice versa or does it not matter at all as both will have to scan the entire table anyway (for Compute Statistics)
Analyzing tables does not have anything to do with Rebuilding Indexes. Both are independent processes.
Click Here to Expand Forum to Full Width