Re: ANALYZE question

From: Charlie Mengler <charliem_at_mwh.com>
Date: Wed, 24 Jul 2002 09:23:43 -0800
Message-ID: <F001.004A1199.20020724092343@fatcity.com>

At the last Open World I attended a couple of sessions where the general advice for 9i DB is to use ANALYZE ESTIMATE without specifying ANY value. A few brief "comparision" tests did show that it got better results than the alternatives tested.

As always, YMMV & HTH

HAND!
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Charlie Mengler
  INET: charliem_at_mwh.com

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). Received on Wed Jul 24 2002 - 12:23:43 CDT