From oracle-l-bounce@freelists.org Thu Sep 30 10:35:41 2004 Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id i8UFZfB06274 for ; Thu, 30 Sep 2004 10:35:41 -0500 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air189.startdedicated.com (8.11.6/8.11.6) with ESMTP id i8UFZfI06268 for ; Thu, 30 Sep 2004 10:35:41 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 10C1272D93D; Thu, 30 Sep 2004 10:41:44 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 14653-19; Thu, 30 Sep 2004 10:41:43 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 31EA172E0D1; Thu, 30 Sep 2004 10:40:30 -0500 (EST) Message-ID: From: Freeman Robert - IL To: "'David '" , "'oracle-l-bounce@freelists.org '" , "'oracle-l@freelists.org '" Subject: RE: MV including clause Date: Thu, 30 Sep 2004 10:38:17 -0500 MIME-Version: 1.0 x-iHateSpam-Checked: Checked by Spam Filter Service at 9/30/2004 9:42:42 AM X-MimeOLE: Checked by Spam Filter Service at 9/30/2004 9:42:42 AM X-AntiAbuse: Checked by Spam Filter Service at 9/30/2004 9:42:42 AM X-Source: Checked by Spam Filter Service at 9/30/2004 9:42:42 AM Content-type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit X-archive-position: 10470 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: FREEMANR@tusc.com Precedence: normal Reply-To: FREEMANR@tusc.com X-list: oracle-l X-Virus-Scanned: by amavisd-new at freelists.org Have you used the dbms_mview.explain_mview procedure. It will tell you exactly why your mview will not refresh. RF -----Original Message----- From: oracle-l-bounce@freelists.org To: oracle-l@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