my bad on the explanation. I have 4 tables. 3 are non-transactional. These are joined in a primary key/foreign key relationship. These are going in the materialized view.
I want to join my 4th table to my materialized view. 1. The application current has code that joins all 4 tables. I dont know if they will re-write this. 2. The refresh on that materialized view is possibly time consuming. Im worried about stale data. I want oracle to determine if its stale or not. If I explicitly hit the materialized view, I have to handle that with code. We do nightly data loads, then the materialized view needs to be reloaded. This could take a little while. > > From: [EMAIL PROTECTED] > Date: 2003/12/26 Fri PM 02:09:27 EST > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > Subject: Re: please help with materialized view question > > Warning: I have not actually used query rewrite in this way, so take this > with a grain of salt. > > If you're joining the MV directly to a table, what is there to rewrite? > > If you were joining the tables that make up the MV, and doing so > on the same key that was used to create the MV, and joining > that result to a transactional table, it would make sense to use > query rewrite. > > Based on your statement though, I don't see the need. > > Clarification? > > Jared > > > > > > > <[EMAIL PROTECTED]> > Sent by: [EMAIL PROTECTED] > 12/26/2003 10:44 AM > Please respond to ORACLE-L > > > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > cc: > Subject: Re: please help with materialized view question > > > I figured it out. > > I have another problem. I create my materialized view. I now want to write > a query that joins it to a transactional table. I want to use query > rewrite. Problem is the join is not on the primary key of either table. > > Is it possible to enable query rewrite without that? I have it in trusted > mode? > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: <[EMAIL PROTECTED] > INET: [EMAIL PROTECTED] > > Fat City Network Services -- 858-538-5051 http://www.fatcity.com > San Diego, California -- Mailing list and web hosting services > --------------------------------------------------------------------- > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > > > >
Warning: I have not actually used query rewrite in this way, so take this
with a grain of salt.
If you're joining the MV directly to a table, what is there to rewrite?
If you were joining the tables that make up the MV, and doing so
on the same key that was used to create the MV, and joining
that result to a transactional table, it would make sense to use
query rewrite.
Based on your statement though, I don't see the need.
Clarification?
Jared
| <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED] 12/26/2003 10:44 AM
|
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject: Re: please help with materialized view question |
I figured it out.
I have another problem. I create my materialized view. I now want to write a query that joins it to a transactional table. I want to use query rewrite. Problem is the join is not on the primary key of either table.
Is it possible to enable query rewrite without that? I have it in trusted mode?
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: <[EMAIL PROTECTED]
INET: [EMAIL PROTECTED]
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
