what is the bitmap index?

Question Posted / esreddy220

3 Answers
5116 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

what is the bitmap index?..

Answer / a g srikanth

Bitmap Index is an index that can be used on low
cardinality columns with a large number of rows. Low
cardinality columns are the ones with less number of
distinct values (eg.gender columns with just two distinct
values Male & Female).

Bitmap indexes are also useful in DWH applications where a
large table is joined with many small tables in a
denormalized star schema.

Is This Answer Correct ?

1 Yes

0 No

what is the bitmap index?..

Answer / daid kumar

bitmap Index is Used mainly in decision support systems
because it returns value in bit like 0 and 1.

Example
CREATE BITMAP JOIN INDEX <index_name>
ON <table_name> (<table_name.column_name>)
FROM <table_name, table_name>
WHERE <join_condition>

Is This Answer Correct ?

0 Yes

0 No

what is the bitmap index?..

Answer / kamala k n

bit map index created on low cardinality columns

Is This Answer Correct ?

0 Yes

0 No

Post New Answer