Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Fact Table Question
Joseph Wilson wrote:
> I have a fact table which is composed of 5 foreign keys and one numeric
> value. Is there any benefit to creating a primary key bitmap index on the 5
> foreign key columns together vs just creating 5 individual bitmap indexes on
> the foreign keys? I know the primary key will perform the unique checking,
> but it seems like the individual indexes will be better used for querying.
> Am I missing something? Is there a reason to go one way or the other?
>
> Thanks,
> Joe
What version of Oracle?
How often will the queries use WHERE clauses with column names in an order other than the one in the proposed composite constraint?
Daniel Morgan Received on Wed Mar 26 2003 - 23:24:02 CST