Re: compute weekly estimate daily which stats will be used ?

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Tue, 5 Feb 2002 06:35:21 +0100
Message-ID: <u607e3e3gp7b1f@corp.supernews.com>

"Ted Chyn" <tedchyn_at_yahoo.com> wrote in message news:44a19320.0202041920.3aac87b1_at_posting.google.com...
> all,
> for large table -compute stats on sunday and estimate stats during
> weekday. which stats will be used for execution plan during regular
> weekday.
>
> thnx in advance
> ted chyn

Obviously the weekday statistics will *replace* the compute statistics.

Regards

--
Sybrand Bakker
Senior Oracle DBA

to reply remove '-verwijderdit' from my e-mail address

Received on Mon Feb 04 2002 - 23:35:21 CST