RE: dbms_stats

[Wolfgang Breitling]

The answer is as usual "it depends". If the table has a reasonably uniform 
row size and the blocks are approximately evenly utilized, then the analyze 
can extrapolate the total number of rows fairly accurately even from a 
small sample. However, if the row size fluctuates wildly, or if the block 
utilization fluctuates heavily, then you need a larger sample for accurate 
estimates of the totals.

At 12:14 PM 5/29/2003 -0800, you wrote:
Hi Wolfgang,

In the grand scheme of things, that probably isn't awful.  However, if the 
analyze can't get the row count right (how easy is that?) then how can I 
trust it to get the rest of the statistics correct?  Just my two cents.

Thanks for your reply.
Lisa
Wolfgang Breitling
Oracle7, 8, 8i, 9i OCP DBA
Centrex Consulting Corporation
http://www.centrexcc.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Wolfgang Breitling
 INET: [EMAIL PROTECTED]
Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).