-
Index Maintenance Plan Help
I have a maintenance plan that Reorganizes, Shrinks, and Stats for all of my databases. Why is it that it only updates Stats on certain tables and not all? Am I doing something wrong?
I am doing the following in order:
1 - Reorganize Index Task: All Tables and Views
2 - Shrink Database Task: Limit 50 MB, Free space 3%
3 - Update Stats Task: All Tables and Views
Any recommendations to do this better will be great!
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
|
|