dbaplusplus_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.
>
>
> Prem
Yes.
--
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org
Received on Thu Oct 19 2006 - 16:31:09 CDT
