Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: INDEX REBUILD
Guang - Below is what Jared said on this topic:
Dennis Williams
DBA, 80%OCP, 100% DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
-----Original Message-----
Sent: Thursday, December 26, 2002 9:14 PM
To: Multiple recipients of list ORACLE-L
Though I have published a script for determining indexes that need to be rebuilt, and then rebuilding them, I have to say that this is almost never necessary.
Why are you rebuilding indexes? About the only reason for ever doing so is that the BLEVEL >= 5.
go to asktom.oracle.com, and do a search on 'index rebuild'.
Currently, the third article may be of interest.
Jared
-----Original Message-----
Sent: Thursday, June 19, 2003 12:34 PM
To: Multiple recipients of list ORACLE-L
Where can I find more detail info about "frequent index rebuilds can reduce your performance" ?
Thanks.
Guang
-----Original Message-----
Sent: Thursday, June 19, 2003 12:00 PM
To: Multiple recipients of list ORACLE-L
Seema - If you analyze in conjunction with rebuilds, you could track with the LAST_ANALYZED column in USER_INDEXES table. That is all I can think of. Why do you ask? Jared has spoken eloquently about how frequent index rebuilds can reduce your performance.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Guang Mei
INET: [EMAIL PROTECTED]
Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services ---------------------------------------------------------------------To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services ---------------------------------------------------------------------To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Thu Jun 19 2003 - 15:07:29 CDT
![]() |
![]() |