Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: explain plan is changing ...

RE: explain plan is changing ...

From: Nicoll, Iain (Calanais) <iain.nicoll_at_calanais.com>
Date: Fri, 14 Sep 2001 02:08:01 -0700
Message-ID: <F001.0038E3CA.20010914015517@fatcity.com>

!! Please do not post Off Topic to this List !!

Does estimate without samples size or percentage not just use 1024 as the sample size?. If you look at dba_tab_columns the samples size will be in there. If the table is not too big could you try it with compute statistics or estimate statistics with 20 percent sample?

Iain Nicoll

-----Original Message-----
Sent: 13 September 2001 21:26
To: Multiple recipients of list ORACLE-L

!! Please do not post Off Topic to this List !!

I have analyzed them today via:

analyze table ... estimate statistics;
analyze table ... estimate statistics for all indexed columns;

No data were added/modified agter that


Terrorist Attacks on U.S. - How can you help? Donate cash, emergency relief information http://dailynews.yahoo.com/fc/US/Emergency_Information/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: g g
  INET: anotheroracledba_at_yahoo.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).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Nicoll, Iain (Calanais)
  INET: iain.nicoll_at_calanais.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 Fri Sep 14 2001 - 04:08:01 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US