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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
