Re: analyze estimate sample size

From: Brian Wisniewski <brian_wisniewski_at_yahoo.com>
Date: Wed, 6 Sep 2000 13:21:05 -0700 (PDT)
Message-Id: <10611.116344@fatcity.com>

Yes you can.

analyze table xyz estimate statistics sample 10000 rows or analyze table xyz estimate statistics sample 10 percent

Just plug in the figures you want.

• Brian
  • Ruth Gramolini <rgramolini_at_tax.state.vt.us> wrote:
    > 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
    >
    > --
    > Author: Ruth Gramolini
    > INET: rgramolini_at_tax.state.vt.us
    >
    > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
    > San Diego, California -- Public Internet access / Mailing
    > Lists
    > --------------------------------------------------------------------
    > To REMOVE yourself from this mailing list, send an E-Mail message
    > to: ListGuru_at_fatcity.com (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).
    >
    

    ---

Do You Yahoo!?
Yahoo! Mail - Free email you can access from anywhere! Received on Wed Sep 06 2000 - 15:21:05 CDT