Home » RDBMS Server » Performance Tuning » Rule for bitmap indexes
Rule for bitmap indexes [message #65374] Fri, 27 August 2004 11:10 Go to next message
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.
Re: Rule for bitmap indexes [message #65375 is a reply to message #65374] Fri, 27 August 2004 11:16 Go to previous messageGo to next message
andrew again
Messages: 2577
Registered: March 2000
Senior Member
This is about the best advise you will find:
http://www.dbazine.com/jlewis3.html
Re: Rule for bitmap indexes [message #65377 is a reply to message #65375] Fri, 27 August 2004 22:03 Go to previous message
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
Previous Topic: SGA shared pool
Next Topic: Oracle over Satellite Bandwidth requirement
Goto Forum:
  


Current Time: Wed Sep 23 12:20:53 CDT 2020