RE: Materialized view

From: Stephen Lee <Stephen.Lee_at_DTAG.Com>
Date: Thu, 26 Jun 2003 10:08:55 -0700
Message-ID: <F001.005BA812.20030626095418@fatcity.com>

For fast refresh, you need to have a snapshot log on the master table and the snapshot must be registered with the master.

Keep in mind, we are only talking about simple, read-only, snapshots here. There are fancier ways of moving data here and there. But I would have to do the RTFM thing before expounding on those.

-----Original Message-----

don't you need a 'count(*)' for refresh fast? Raj

Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. QOTD: Any clod can have facts, having an opinion is an art !

-----Original Message-----
Sent: Thursday, June 26, 2003 11:50 AM
To: Multiple recipients of list ORACLE-L

I'm not sure if you want to improve the query, or the replication process. If it's the replication process, one other option is 'refresh force'. Then,

if I understand the docs correctly, you get a fast refresh if it can; and if

refresh fast is not possible, then refresh complete. That's the theory. Now whether or not it actually works that way .... For what it's worth, I always use 'refresh force'. -----Original Message-----
How can I create materialized view(mv) for the following statement using 'refresh fast' method.
I can use 'refresh complete' option to create this mv, but how can I use 'refresh fast' option for the below statement in order to improve performance in query.
Any workaround ?
select mas.salesrep_id,sum(del.qty*del.price)-sum(del.discount) from
sales_master mas,
sales_details del
where
mas.transaction_id =del.transaction_id
group by
mas.salesrep_id.
Thanks in advance
--

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

Author: Stephen Lee
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).
--

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

Author: Stephen Lee
INET: [EMAIL PROTECTED]

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------