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

Home -> Community -> Usenet -> c.d.o.server -> Re: Statistics FULL and Partial

Re: Statistics FULL and Partial

From: Daniel Morgan <damorgan_at_x.washington.edu>
Date: Fri, 16 Jan 2004 08:04:24 -0800
Message-ID: <1074268991.12710@yasure>


Tyler Smith Watu wrote:

> I like to know what difference it makes when statistics are done at
> 100% and say 25 or 40%.Your expert opinions are appreciated
> TIA
>
> TY

FULL will, by definition be the most accurate. But on large tables may take more time than is reasonably available. One should use the highest percentage, for the most accuracy, allowable based on time constraints.

The more accurate the analysis ... the more likely the CBO will make the correct choice.

-- 
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)
Received on Fri Jan 16 2004 - 10:04:24 CST

Original text of this message

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