OraFAQ Forum: Performance Tuning » cardinality in bitmap index

Home » RDBMS Server » Performance Tuning » cardinality in bitmap index (Oracle 9.2.0.6.0)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

cardinality in bitmap index [message #388610]

Wed, 25 February 2009 12:10

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

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Depends on so many things that no one can answer, like key size and values life.

Regards
Michel

Report message to a moderator

Re: cardinality in bitmap index [message #388619 is a reply to message #388610]

Wed, 25 February 2009 12:34

BlackSwan
Messages: 26766
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

Report message to a moderator

Re: cardinality in bitmap index [message #388772 is a reply to message #388619]

Thu, 26 February 2009 03:18

saurabhshukla
Messages: 6
Registered: February 2009
Location: Gurgaon

Junior Member

Many thanks..

Report message to a moderator

Previous Topic:	Joining Oracle Text results with multiple tables / Performance Problems
Next Topic:	Subpartitions number

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Nov 22 18:15:19 CST 2024