Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> DBMS_STATS gather stale option
I use DBMS_STATS to gather statistics for all tables in an Oracle
8.1.7.3 database. I would like use the GATHER STALE option of
GATHER_SCHEMA_STATS to automatically collect statistics. However, the
tables in this database vary widely in size and there is also a
partitioned table.
If I execute DBMS_STATS.GATHER_SCHEMA_STATS with the GATHER STALE option, will it gather statistics based on how statistics were gathered previously on each table (compute, estimate, and partition), or will it compute statistics on all tables no matter the type or size of the table? There is no GATHER STALE option associated with GATHER_TABLE_STATS. Thanks for your help.
Gail
-- Department of Genetics Phone: (650) 498-7145 School of Medicine Fax: (650) 723-7016 Stanford University Email: gail_at_genome.stanford.edu Stanford, CA 94305-5120 URL: http://genome-www.stanford.edu/Received on Mon Oct 28 2002 - 15:32:17 CST
![]() |
![]() |