Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: why people delete statistics bore running statistics
I have seen people do that as well. Running stats will generate new
stats. Deleting them is bad because it will force queries to use rule
based optimization during the time from the delete and the time the
stats for those specific tables get put back.
On Oct 19, 4:31 pm, DA Morgan <damor..._at_psoug.org> wrote:
> dbaplusp..._at_hotmail.com wrote:
> > I am using Oracle 10g r1 on Windows 2000 Server as well as Oracle9i on
> > HP UNIX. 11i
> > I run following sql to gather staistics:
>
> > sys.dbms_stats.gather_schema_stats(ownname=>'SAPPHIRE', cascade=>TRUE);
>
> > for SAPPHIRE schema.
>
> > I have seen some people delete staistics before running above
> > statement. Won't above statement regenerate the statistics for all
> > tables/indexes, overwriting whatever was there.
>
> > PremYes.
> --
> Daniel A. Morgan
> University of Washington
> damor..._at_x.washington.edu
> (replace x with u to respond)
> Puget Sound Oracle Users Groupwww.psoug.org
Received on Sun Oct 22 2006 - 23:07:48 CDT