Re: How do we know that an index need to be rebuilt.

That's the doc. i mailed raju.
Thanx Mladen.

can i add a question here :

when is it appropriate to use BITMAP index ? seems it has lot of restrictions.
read docs about it ...still confused.

say, i have a big table with 50,000,000 records in a OLTP env. it has column SEX which will have either MALE or FEMALE. the table will have frequent insert/delete too. often this SEX column is included in many queries.

this being my case, can i use bitmap index on this column ?

or can u give a simple example for when a bitmap index can be used ?

Regards,
Jp.

22-09-2003 17:04:40, Mladen Gogala <mgogala_at_adelphia.net> wrote:
>There is a Metalink note 77574.1 entitled "Guidelines on When to Rebuild a B-
>Tree Index" which explains how to use "validate structure" and index_stats
>table. It is far too scientific to ever put into the script. Explanation
>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.

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Prem Khanna J
  INET: jprem_at_kssnet.co.jp

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: ListGuru_at_fatcity.com (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).