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 -> Re: bitmap join index error

Re: bitmap join index error

From: Daniel Roy <danielroy10junk_at_hotmail.com>
Date: 18 Jul 2003 12:08:13 -0700
Message-ID: <3722db.0307181108.15a87130@posting.google.com> 





Bitmap join indices are intended for the fact table of a star schema.
I don't see why you would use this feature for a dimension table. Why
not a b-tree index?



Daniel



> My goal is not a star transformation. I really want to create index on

> dimension table ma14_feats. See the explanation in my previous message.

> 

> Thank you,

> Misha.

Received on Fri Jul 18 2003 - 14:08:13 CDT












Original text of this message













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