RE: Estimate versus Compute

From: Powell, Mark D <mark.powell_at_eds.com>
Date: Mon, 25 Jul 2005 12:59:22 -0400
Message-ID: <5A14AF34CFF8AD44A44891F7C9FF41050395B9D6@usahm236.amer.corp.eds.com>

We have always used an estimate with a row count since Oracle managed to provide a working version of the command.

analyze table o.t estimate statistics sample 150000 rows;

You can do the same with dbms_stats.

HTH -- Mark D Powell --

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Kevin Lange Sent: Monday, July 25, 2005 12:47 PM
To: Oracle-L_at_freelists.org
Subject: Estimate versus Compute

Evening all;
We are starting to have issues with our analyze routines running too long on our databases.

We are trying to come up with a plan that says "At X number of rows and Y cardinality, start running with Estimated Statistics".

Does anyone have any guidlines on this at all that I could read/lookat/use ?

Thanks

Kevin

--
http://www.freelists.org/webpage/oracle-l

Received on Mon Jul 25 2005 - 12:02:27 CDT