The maintenance plans in SQL 2000 for reindexing only cater for doing whole databases at once.
This is causing me some serious grief with it running for 5-6 hours and contention with the backup.
I want to be able to reindex individual tables.
I know about the reindex command and also dropping and doing the indexes from scratch.
REINDEX for two tables however had not yielded great results (> 1 minute response times for getting back 42 results using an inner join).
So I thought I'd ask here.
Given 45 tables ranging from 500,000 rows to 110,000,000 rows (all exist in the same database) most of which are in the millions+ rows what would you consider the best way is to reindex them?
Are there any scripts for just doing selected tables which can be scheduled?