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 -> Re: Fact Table Question

Re: Fact Table Question

From: DA Morgan <damorgan_at_exxesolutions.com>
Date: Wed, 26 Mar 2003 21:24:02 -0800
Message-ID: <3E828AF2.CC7F2F0D@exxesolutions.com>


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

Original text of this message

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