Re: Unindexed FK and DW

From: <mfullerton_at_gmail.com>
Date: 7 Nov 2006 19:44:02 -0800
Message-ID: <1162957441.939699.213390@f16g2000cwb.googlegroups.com>

To add to what everyone has said:

Test with and without FK's. The tried and true answer is see how it effects the common queries against the particular tables. Try bitmap join indexes as well and ordinary bitmap indexes. I suggest reading the data warehouse oracle guide for your particular version, it is quite comprehensive but always test for yourself. See what does the least LIO and gives you the best execution plans.

Mike

klabu wrote:
> Is Unindexed FK a common thing in Data Warehouse ?
>
> thanks
>
> 10gR2
Received on Tue Nov 07 2006 - 21:44:02 CST