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

Home -> Community -> Usenet -> c.d.o.misc -> Fact Table Question

Fact Table Question

From: Joseph Wilson <me_at_home.now>
Date: Thu, 27 Mar 2003 00:58:58 GMT
Message-ID: <m1sga.2736$2x2.1154619@dca1-nnrp1.news.algx.net>


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

Original text of this message

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