[ 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