for the rule of thumb is simple: if number of index blocks is big that means
that the number of deleted entries is likely to be big, so let's rebuild it.
As I said, rebuilding indexes is not often necessary and is usually done for
all the wrong reasons. Quality of the rule of thumb, therefore, doesn't really
matter.
On 2003.09.22 03:19, Prem Khanna J wrote:
Read ur interesting reply for the query Mladen and learnt a new "rule of thumb" from u today.
i sent the doc. to Raju ONLY adn NOT to the list. it's just the body of the mail u r seeing there.
Regards, Jp.
22-09-2003 15:49:40, Mladen Gogala <[EMAIL PROTECTED]> wrote:
>Attachments are stripped from the list messages.
>On 2003.09.22 02:24, Prem Khanna J wrote: >> Hi Raju, >> Check the doc. i have attached.
-- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Prem Khanna J 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).
-- Mladen Gogala Oracle DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala 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).