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

Home -> Community -> Usenet -> c.d.o.misc -> Re: Looking for Performance with a Where In Clause

Re: Looking for Performance with a Where In Clause

From: DA Morgan <damorgan_at_psoug.org>
Date: Tue, 06 Dec 2005 11:18:44 -0800
Message-ID: <1133896703.974961@jetspin.drizzle.com>


Rayb wrote:
> I have two pieces of SQL that as very similar, but are treated very
> differently by oracle (9.2.0.1 by the way).
>
> This sql was originally in a package.proc. The real version selects
> from more than just the voter table, I have removed the extra columns
> for simplicity.
>
> The SQL statements and explain plans are at bottom of post.
>
> SQL 1 runs in .02 seconds while SQL 2 takes 8 or so seconds. Any
> thoughts as to why?

Could be a lot of things. But I'd start by patching 9.2.0.1 to 9.2.0.6 or above followed by running DBMS_STATS.

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)
Received on Tue Dec 06 2005 - 13:18:44 CST

Original text of this message

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