RE: BLEVEL on bit-mapped indexes

Govind,  

Large indexes would tend to be 'taller'. However, I believe you can achieve a flatter structure for the same index by using a larger block size. If you are on 9i (any release?) then you could probably create new tablespaces with larger blocksizes and recreating these indexes therein. Not sure if this applies to BIs though...  

John Kanagaraj
Oracle Applications DBA
DBSoft Inc
(W): 408-970-7002

So WHO is the Reason for the Season?! Write me for details!

• The opinions and statements above are entirely my own and not those of my employer or clients **

-----Original Message-----
Sent: Monday, December 09, 2002 3:34 PM
To: Multiple recipients of list ORACLE-L

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: John Kanagaraj
  INET: john.kanagaraj_at_hds.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).