-
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)
Thanks,
- Rajeev
Rajeev Suri
-
Analyzing tables does not have anything to do with Rebuilding Indexes. Both are independent processes.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|