Re: GATHER_SCHEMA_STATS always gathers histograms..!

From: <mccmx_at_hotmail.com>
Date: 15 Nov 2006 07:54:54 -0800
Message-ID: <1163606094.252516.283660@f16g2000cwb.googlegroups.com>

> Perhaps the following is of interest >>
> GATHER AUTO: Gathers all necessary statistics automatically. Oracle
> implicitly determines which objects need new statistics, and determines
> how to gather those statistics. When GATHER AUTO is specified, the only
> additional valid parameters are ownname, stattab, statid, objlist and
> statown; all other parameter settings are ignored. Returns a list of
> processed objects.
> <<

Aha....! That makes sense - I need to re-read the docs...

I thought GATHER AUTO would gather stats for tables with STALE and EMPTY stats.

I will try GATHER STALE instead...

Thanks

Matt Received on Wed Nov 15 2006 - 09:54:54 CST