Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Bitmap Indexes with Star Transformation Enabled
Do bitmap indexes perform/join differently when all joins are
bitmap indexes (as opposed to some being b-tree and some being bitmap).
I understand that bitmaps must be chosen based on low cardinality but if there is one dimension table and one fact table being joined and ALL of the indexes used on the fact table are bitmap, does the star transformation parameter handle the execution plan differently than it would if some fact indexes were b-tree?
Thanks
Donna
Received on Mon Feb 25 2002 - 15:28:53 CST