Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> why people delete statistics bore running statistics
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 Received on Thu Oct 19 2006 - 16:11:06 CDT