What are bitmap indexes and how and why
are they used?
Bitmap indexes are used to enhance the join
performance in STAT design. Don’t go by the myth of cardinality(Bitmaps are
used on for lower cardinality.). It is a major component to enhance the joins
between facts and dimension. It becomes more important if you are using Oracle
propriety star_transformation_enabled=TRUE parameter in init.ora file.
No comments:
Post a Comment