Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Looking for Performance with a Where In Clause
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