Re: Large table extents

Cheryl Kendricks wrote: > > Yes to question 1. Yet, if you have an index and set up query correctly > to use index it will use it. But once a table becomes highly fragmentted > either due to delete or insertions it is a good idea to unload and reload > the table. Or if you have enough space within the dbspace just alter the > index to cluster (this will also unfrag the table). > > Snip...Snip... Altering to Cluster is a nice quick & dirty method to defrag tables, just make sure you have enough log space to do the entire transaction, or you'll lock the engine up tight. Restore from archive is about all you can do. I've done this a couple of times & boy did I feel dumb... Greg Moye - EDS Plano