Re: analyze estimate sample size

From: Stephen Andert <StephenAndert_at_firsthealth.com>
Date: Wed, 06 Sep 2000 09:37:10 -0600
Message-Id: <10611.116306@fatcity.com>

Ruth:

I haven't looked it up so the syntax might be a bit off, but basically

execute dbms_utility.analyze_schema('PROD','ESTIMATE','20');

where 20 is the percent of each table that you want to be used for the = estimate.

FYI: This doesn't work for us because we have a set of equipartitioned = tables where some have no entries for some index values and this causes = 8.1.6 to crash.

YMMV Stephen Andert

>>> "Ruth Gramolini" <rgramolini_at_tax.state.vt.us> 09/06 8:29 AM >>>
Hello all,

Can anyone tell me if you can change the sample size used when you analyze = a
schema with the 'estimate' option. I would like to make it bigger.

Thanks in advance,
Ruth B. Gramolini
ORACLE & DB2 DBA
VT Dept. of Taxes
ph# 802.828.5708
fax# 802.828..3754
rgramolini_at_tax.state.vt.us=20

---

If you're bored, then visit the list's website: http://www.lazydba.com = (updated daily)
to unsubscribe, send a blank email to oracledba-unsubscribe_at_quickdoc.co.uk= =20
to subscribe send a blank email to oracledba-subscribe_at_quickdoc.co.uk=20 Received on Wed Sep 06 2000 - 10:37:10 CDT