OraFAQ Forum: Performance Tuning » Rule for bitmap indexes

Home » RDBMS Server » Performance Tuning » Rule for bitmap indexes

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

Rule for bitmap indexes [message #65374]

Fri, 27 August 2004 11:10

Kevin Darden
Messages: 6
Registered: July 2004

Junior Member

Is there a general rule of thumb or forumula�to help decide�when to use a bitmap index? I know that you should use them if you have low cardinality, but I assume�that's in�relation to the size of the table.

Report message to a moderator

Re: Rule for bitmap indexes [message #65375 is a reply to message #65374]

Fri, 27 August 2004 11:16

andrew again
Messages: 2577
Registered: March 2000

Senior Member

This is about the best advise you will find:
http://www.dbazine.com/jlewis3.html

Report message to a moderator

Re: Rule for bitmap indexes [message #65377 is a reply to message #65375]

Fri, 27 August 2004 22:03

BhavinShah
Messages: 105
Registered: February 2004

Senior Member

Hi,
There is no thumb rule but.. you should use bitmap index when your column has less distinct value and the size of table is significatly large

bhavin

Report message to a moderator

Previous Topic:	SGA shared pool
Next Topic:	Oracle over Satellite Bandwidth requirement

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Apr 20 09:52:48 CDT 2024