RE: Materialized view

From: Jamadagni, Rajendra <Rajendra.Jamadagni_at_espn.com>
Date: Thu, 26 Jun 2003 09:47:34 -0700
Message-ID: <F001.005BA707.20030626084453@fatcity.com>

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-----
From: Stephen Lee [mailto:[EMAIL PROTECTED]] Sent: Thursday, June 26, 2003 11:50 AM
To: Multiple recipients of list ORACLE-L Subject: RE: Materialized view

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).

*********************************************************************This e-mail 

message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank

you.*********************************************************************1

Received on Thu Jun 26 2003 - 11:47:34 CDT