Re: Data load ideas

From: Tim Gorman <tim_at_sagelogix.com>
Date: Tue, 04 May 2004 17:52:05 -0600
Message-ID: <BCBD88C5.145AC%tim@sagelogix.com>

For query rewrite on MVs, you would need valid FK constraints only if you have the parameter QUERY_REWRITE_INTEGRITY = ENFORCED and you really are trying to use this mechanism to prevent "stale data" from being used in the MV. By the way, this is also the default setting for this parameter, and this is a major cause for QR not working for the unwary...

You don't need RI constraints to get star transformations to work, just the parameter STAR_TRANSFORMATION_ENABLED = TRUE and bitmap indexes all over the place...

on 5/4/04 5:07 PM, Jared.Still_at_radisys.com at Jared.Still_at_radisys.com wrote:

>> They cause no harm if they are "RELY" (i.e. unenforced), allowing the

> DBA to

>> create ERDs...

> It seems you might also want these for Materialized views and Star
> transformations IIRC. I haven't work in a DW/DM environment for
> awhile though...
>
> Jared
>
>
>
>
> ----------------------------------------------------------------
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> ----------------------------------------------------------------
> To unsubscribe send email to: oracle-l-request_at_freelists.org
> put 'unsubscribe' in the subject line.
> --
> Archives are at http://www.freelists.org/archives/oracle-l/
> FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
> -----------------------------------------------------------------

Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.

--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Received on Tue May 04 2004 - 18:49:37 CDT