October 12, 2009 at 12:10 pm
Hi,
I know it depends. We re-index everyday before full backup through maintenance plans. These maintenance plans have re-org and and check database integrity steps after the backups run, we don't even have update statistics. These are set by previous DBA. We do lots of updates and deletes for few tables. Can someone explain me clearly of these two indexing systems.
Thanks,
VG
October 12, 2009 at 12:16 pm
Most dedicated DBA's like to roll their own maintenance routines instead of using maintenance plans. One issue with Reindex/reorg using maintenance plans is that every index is touched regardless of need.
I typically recommend checking out Michelle Ufford's index maintenance script[/url] as a starting point. Remember that index statistics are updated whenever an index is rebuilt.
Here is another good post about index and statistics maintenance
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply