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: [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).
