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?
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: 1734
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.
Previous Topic: Modifying a plan
Next Topic: Joining Oracle Text results with multiple tables / Performance Problems
Goto Forum:
  


Current Time: Sat Dec 03 01:02:04 CST 2016

Total time taken to generate the page: 0.25973 seconds