RE: explain plan is changing ...

From: g g <anotheroracledba_at_yahoo.com>
Date: Thu, 13 Sep 2001 12:30:44 -0700
Message-ID: <F001.0038DBDF.20010913122622@fatcity.com>

!! 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

• "Nicoll, Iain (Calanais)" <iain.nicoll_at_calanais.com> wrote:
  > !! Please do not post Off Topic to this List !!
  >
  > Have they been analyzed recently? as if you were
  > using histograms then if
  > the last two months were added after your last
  > analyze it would think they
  > were fairly rare.
  >
  > Cheers
  >
  > Iain Nicoll
  >
  > -----Original Message-----
  > Sent: 13 September 2001 19:11
  > To: Multiple recipients of list ORACLE-L
  >
  >
  > !! Please do not post Off Topic to this List !!
  >
  > Hi all:
  >
  >
  > I have a query, which behaves differently depending
  > on the input data (month/year). I have more than
  > 15month worth of data in the database. The query
  > is completed under 1 minute for the first 13 month,
  > but for the last two months it just doesn't finish.
  > I
  > have cancelled it after 36 minutes. The explain
  > plans
  > are
  > differ in that the "quick" query uses more hash
  > jonts,
  > while "slow" one utilizes more nested loops. All the
  > tables are analyzed. This must have something to
  > do with the data distribution, but what? Can anyone
  > shed some light onto that?
  >
  > tia
  >
  

  ---

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).

Received on Thu Sep 13 2001 - 14:30:44 CDT