bitmap index

[krishhhna]

what is the bitmap index ? how it can be used? what is the difference between bitmap index and other indexes?

[Rakeshy]

what is the bitmap index ? how it can be used? what is the difference between bitmap index and other indexes?

hi,
Bitmap Index is useful in Dataware housing or Historical Database. Oracle suggest to create bit map index on those column which have large number of repetative entries e.g. Gender. ActiveStatus.

In BitMap index with 1(ON) or 0 is stored along with value of index key and rowid. It is stored in matrix form . 1 and 0 are useful in AND ,OR operations.

Syntax:

CREATE BITMAP INDEX index_name
on table_name(colu mn_name)
/

Best Regards

Rakesh Yadav
98204 70547

[debasisdas]

Find details of bitmap indexes here.

[gintsp]

what is the bitmap index ? how it can be used? what is the difference between bitmap index and other indexes?

My blog entry has quite many links explaining B-tree, bitmap indexes by various Oracle experts.

Gints Plivna
http://www.gplivna.eu

[vivekmcm]

What is bitmap and
difference between BTree & bitmap index