Home » RDBMS Server » Performance Tuning » cardinality in bitmap index (Oracle 9.2.0.6.0)
cardinality in bitmap index [message #388610] Wed, 25 February 2009 12:10 Go to next message
saurabhshukla
Messages: 6
Registered: February 2009
Location: Gurgaon
Junior Member
Hi,
I am unable to corelate the terms cardinality and blevel:
Suppose I have 100000 rows, I have one bitmap index on a column for the table. What would be the blevel if cardinality is 100?

[Updated on: Wed, 25 February 2009 12:11]

Report message to a moderator

Re: cardinality in bitmap index [message #388616 is a reply to message #388610] Wed, 25 February 2009 12:21 Go to previous messageGo to next message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Depends on so many things that no one can answer, like key size and values life.

Regards
Michel
Re: cardinality in bitmap index [message #388619 is a reply to message #388610] Wed, 25 February 2009 12:34 Go to previous messageGo to next message
BlackSwan
Messages: 25050
Registered: January 2009
Location: SoCal
Senior Member
http://download.oracle.com/docs/cd/B19306_01/server.102/b14220/schema.htm#sthref1022


You really need to learn how to Read The Fine Manuals found at
http://tahiti.oracle.com
Re: cardinality in bitmap index [message #388772 is a reply to message #388619] Thu, 26 February 2009 03:18 Go to previous message
saurabhshukla
Messages: 6
Registered: February 2009
Location: Gurgaon
Junior Member
Many thanks..
Previous Topic: Joining Oracle Text results with multiple tables / Performance Problems
Next Topic: Subpartitions number
Goto Forum:
  


Current Time: Sat Dec 10 15:03:59 CST 2016

Total time taken to generate the page: 0.09118 seconds