Home » RDBMS Server » Performance Tuning » blevel in bitmap index (Oracle 9.2.0.5.0, AIX 5.3.0.0)
blevel in bitmap index [message #388416] Tue, 24 February 2009 11:21 Go to next message
saurabhshukla
Messages: 6
Registered: February 2009
Location: Gurgaon
Junior Member
Hi,
We have a DWH database having so many bimap indexes and a few b-tree indexes also. I wanted to know what is the significance of blevel column in user_indexes in terms of bitmap indexes and how the performance can be improved as if the blevel goes beyond 10?
To mitigate the performance issue do we need to drop and recreate bitmap index or any other remedy can be applied?

Report message to a moderator

Re: blevel in bitmap index [message #388526 is a reply to message #388416] Wed, 25 February 2009 03:44 Go to previous message
babuknb
Messages: 1736
Registered: December 2005
Location: NJ
Senior Member
>>To mitigate the performance issue do we need to drop and recreate bitmap index or

I think NOT Require; Try to analyze your index.

Report message to a moderator

Previous Topic: Modifying a plan
Next Topic: Joining Oracle Text results with multiple tables / Performance Problems
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Jun 28 01:21:22 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.