April 8, 2004 at 8:43 am
Does anyone know how to exclude certain tables from reindexed in the database maintenance job - optimization. In most of my databases there are a couple of very large tables (that constitute ~ 90% of the db size) and lots of small tables. I reindex / defragment those large tables manually. I would like the small tables (there are hundreads of them) handled by the DB optimization job. How ever, by default the job will reindex all the tables, including the large ones. Is there any way to exclude them (like excluding some tables for auto statistics generation)?
April 8, 2004 at 9:16 am
script dbcc dbreindex to exclude those 'large tables'
April 8, 2004 at 10:02 am
You could create a DTS package within EM. You can specific which objects to optimize (large tables vs small tables). You can then execute this package manually - or schedule it.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply