Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: ANALYZE %

Re: ANALYZE %

From: Peter Moore <ptmoore_at_sequent.com>
Date: 1996/12/23
Message-ID: <32be6523.7216412@news.sequent.com>#1/1

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US