RE: BLEVEL on bit-mapped indexes

From: <Govind.Arumugam_at_alltel.com>
Date: Mon, 09 Dec 2002 15:33:51 -0800
Message-ID: <F001.00515BF2.20021209153351@fatcity.com>

According to oracle documentation or metalink sources, if the BLEVEL were to be more than 4, it is recommended to rebuild the index.  

select index_name, blevel,
decode(blevel,0,'OK BLEVEL',1,'OK BLEVEL', 2,'OK BLEVEL',3,'OK BLEVEL',4, 'OK BLEVEL','BLEVEL HIGH') OK
from dba_indexes
where owner = '<owner-name>';  

When troubleshooting a performance problem in a data warehousing environment I found that some of the indexes had BLEVEL at 5 or 6.  

I am curious to know whether these indexes are candidates for rebuild. Should be looking at BLEVEL for bit-mapped indexes at all? I am not that experienced in bit-mapped indexes hence posting it to the group.  

Thanks in advance.  

Govind

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: <Govind.Arumugam_at_alltel.com
  INET: Govind.Arumugam_at_alltel.com

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). Received on Mon Dec 09 2002 - 17:33:51 CST