RE: Q... dbms_snapshot.refresh

From: Christian Antognini <Christian.Antognini_at_trivadis.com>
Date: Tue, 1 Mar 2005 22:45:43 +0100
Message-ID: <2CF83791A616BB4DA203FFD13007824A02143E3F@MSXVS02.trivadis.com>

Ciao Bryan

>we have materialized views being updated nightly by the refresh job.
>can someone tell me if that will rebuild the index and/or compute
>statistics associated to it?

The refresh job=20
a) doesn't rebuild the index (the index is kept up-to-date by the DML = statements executed on the container table) b) doesn't recomputed the associated statistics

HTH
Chris

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

Received on Tue Mar 01 2005 - 16:48:54 CST