Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Fact Table Question
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
Received on Wed Mar 26 2003 - 18:58:58 CST