Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Bitmap Indexes with Star Transformation Enabled

Bitmap Indexes with Star Transformation Enabled

From: Donna <dhoffman0917_at_yahoo.com>
Date: 25 Feb 2002 13:28:53 -0800
Message-ID: <79808a91.0202251328.1514910a@posting.google.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US