I've just taken over responsibility for an Oracle 7 system running on Unix. Performance has taken a bit of nose dive in recent months. The amount of data has not increased dramatically. I've tried killing off non-essential processes on the server, and am now wondering if rebuilding the indexes would help - apparrently this was done on the system a couple of years ago to good effect. Despite what it says in the Oracle manuals, index performance will degrade as the amount of data grows. Specifically, as the number of leafs in an index increases and the logical order of leafs becomes increasingly out of sync with the physical order. Is there any way of re-compiling/optimizing the existing indexes without dropping & re-creating them? Cheers, Colin Received on Mon Mar 17 1997 - 00:00:00 CET
Is there any way of re-compiling/optimizing the existing indexes without dropping & re-creating them?
Cheers,
Colin
Original text of this message
