Re: How many people here rebuid index regularly?

> I realise this would take time, but have you considered a treedump of
> the indexes before and after the rebuild:
>
> alter session set evnts = 'immediate trace name treedump level <index
> object id>';
>
> You should see considerable differences in the dump files for a given
> index if the rebuild of it improves performance. And those file pairs
> with differences would indicate the indexes upon which you should
> concentrate your rebuild efforts.

Comparing index sizes before and after rebuild would probably reveal all there is to know. Received on Sat Oct 06 2007 - 02:13:40 CDT