RE: Q... dbms_snapshot.refresh

From: "Christian Antognini" <Christian.Antognini@xxxxxxxxxxxx>
To: <bunjibry@xxxxxxxxx>
Date: Tue, 1 Mar 2005 22:45:43 +0100

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

RE: Q... dbms_snapshot.refresh

Other related posts: