sheela

• Sep 7th, 2005

 

Bitmap indexes are most appropriate for columns having low distinct values

samarem

 Profile Answers by samarem 

• Mar 10th, 2006

 

We can use bitmap index where cardinality is very low like gender column or color column.

Nitin Singhal

DBA(LGEIL)

hemant shrimali

• Apr 19th, 2006

 

hi,

  i have 2 years exp as  oracle dba. and right now i find job of oracle dba. send me if any suggestion to find job of my profile. and i want to update my resume so i need resume of seniar dba. so i explained each terms in bater way. currently working in AC NIELSIEN ORG-MARG.

thank you

hemant shrimali

FROM -BARODA. 

rajesh chadalawada

• Dec 2nd, 2006

 

 bitmap indexes are used in 1) wher we have low cardinality

                                      2) wher we have multiple loops like "while"

                                      3) they r much prefered in "Warehousing" technology.

RASH

• Mar 24th, 2007

 

The explanations are above, read further in the concepts manual.

I would advice caution when using these, as they can cause severe conention when used in Update/Insert Intensive / OLTP environs.
This is because of the way the bitmap index is organized:
Value1:rowid,rowid,rowid........
Value2:rowid,rowid,rowid........

rohit

• Jul 28th, 2011

 

We use bitmap indexes on tables with fairly static low cardinality values (a small number of different values which do not change very often).
It is used in long size table containing 'n' no of records with duplicate records.