Re: vacuum analyze again...

[ Charset ISO-8859-1 unsupported, converting... ]
> Hi,
>
> In Oracle, there are 2 ways to do the equivalent of vacuum analyze :
>
> * analyze table xx compute statitics
> * analyze table xx estimate statistics
>
> In the second form, you can tell on what percentage of the file you
> will do your stats. This is useful to make a quick analyze on huge tables
> that have a homogenous dispersion.
>
> Is there a way to "estimate" the statistics that vacuum analyze will
> use instead of "computing" them ?

No, we have no ability to randomly pick rows to use for estimating
statistics.  Should we have this ability?

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026