Re: When should I reorg?

Wardell, by the way the number of extents a table or index is in will usually not affect DML performance except in those cases where the table bocks are largely empty and you are full table scanning. Then a rebuild wherre you pack the blocks full would likely run faster than before the reorg. If the blocks are full then reading a 100M table stored in 1 extent or 100 extents is not likely to matter. This fact means the extent information you posted is usually not very helpful in solving performance issues.

What is interesting is that you said that "many new rows were added" recently. Where the CBO statistics updated to reflect the new data quantity. Bad statistics often result in bad plans.

HTH -- Mark D Powell -- Received on Tue Aug 30 2005 - 15:25:38 CDT