This type of indexes normally used to create on low cardinality columns. Low cardinality column means, which is going to have very less type of values. For example: Supplier type would be internal or external. These indexes would be created in Data warehouse tables to improve the performance. We can create this index on column or joining of tables also.
http://www.orafaq.com/wiki/Bitmap_index
No comments:
Post a Comment