Re: When should I reorg?

If you add rows, you add data. The more data you have, the more you have to read when querying the table. The more you have to read, the longer it will take...

A reorganization of a table should be considered when 1) Empirical testing demonstrates that the performance benefit outwieghs the time required to rebuild the table AND (a very important AND)
2) The underlying issue that caused a reorganization to be required has been identified and fixed.

If you had just deleted 90% of the rows of a table AND were never going to insert more rows AND many queries were full table scans, a table rebuild would probably be beneficial. Received on Tue Aug 30 2005 - 13:34:21 CDT