Re: bitmap join index error

danielroy10junk_at_hotmail.com (Daniel Roy) wrote in message news:<3722db.0307150752.2b6ab9de_at_posting.google.com>...
> I did more testing on your case, and it seems to be a "star
> transformation" case, with ma14_docs and ma14_feats as the dimension
> tables, and ma14_doc_feats the fact table. My question is why would
> you want to create a bitmap join index on a dimension table
> (ma14_feats)? It seems that what you would want is:
>
> create bitmap index ma14_doc_feats_bitmap1
> on ma14_doc_feats(d.doc_id, f.feat_id)
> from ma14_feats f, ma14_docs d, ma14_doc_feats dfi
> where f.feat_id = dfi.feat_id
> and d.doc_id=dfi.doc_id;
>
> That worked for me, with the same tables and constraints' definitions
> that you defined (i.e. a unique constraint on (feat_id, doc) of table
> ma14_doc_feats).

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 Thu Jul 17 2003 - 08:22:28 CDT