Re: ANALYZE %

Jon,

I'm not sure if I follow your question properly or not, but...

If you ANALYZE tables with any sample size over 50% the analysis performed will *always* be a COMPUTE, not an ESTIMATE.

See the Oracle Server Administrators Guide (V7.1) for more details.

PT

jglickma_at_lynx.dac.neu.edu (jon glickman) wrote:

> Does anybody understand why I am seeing no change in the ALL_TABLES,
> DBA_TABLES... for the analyze sample 70 percent option of
> when I query these tables for small databases.
Received on Mon Dec 23 1996 - 00:00:00 CST