Re: Large # Items in IN () Very Slow

From: Jonathan D. Trumbull <Jonathan.Trumbull_at_abbott.com>
Date: 5 Nov 2002 08:14:07 -0800
Message-ID: <266c2da3.0211050814.612171f@posting.google.com>

Pablo,

See my response to Jonathan Lewis. Basically I was passing a list of integers to query a column of VARCHAR2--changing the column type to NUMBER fixed it. Because of this Oracle was maxing out the CPU. Not sure if this is by design or a bug.

Thanks anyway!

--Jonathan

Pablo Sanchez <pablo_at_dev.null> wrote in message

> Ack, isn't tht always the case ... when you run a full table scan on
> the table, does it take the same amount of time? If not, sounds like
> a bug and since you don't have the source code, you're only bet is
> going to be to log a call with Tech Support.
Received on Tue Nov 05 2002 - 10:14:07 CST