RE: MV including clause

From: Freeman Robert - IL <FREEMANR_at_tusc.com>
Date: Thu, 30 Sep 2004 10:38:17 -0500
Message-ID: <F5E885BEF9540D47A7BDC03CF16880870A7D512F@tuscil_ex1>

Have you used the dbms_mview.explain_mview procedure. It will tell you exactly why your mview will not refresh.

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

From: oracle-l-bounce_at_freelists.org
To: oracle-l_at_freelists.org
Sent: 9/30/2004 9:41 AM
Subject: MV including clause

Does anyone have expeirence with using including clause on a materialized
view and can make a comparision of the overhead of including vs excluding?
Any other hints, tips, pros, cons would be great. I have a complex query that won't work with excluding clause as an MV. Thanks
--

..
David

--

http://www.freelists.org/webpage/oracle-l
--

http://www.freelists.org/webpage/oracle-l Received on Thu Sep 30 2004 - 10:35:41 CDT