Re: Large # Items in IN () Very Slow

Pablo Sanchez <pablo_at_dev.null> wrote in message

> That's a bit ... absurd! <g> What seems to be happening is that you
> have a full in-memory tablescan.
>
> Have you considered bulk loading the data into a 'scratch' table, then
> doing a join back to SomeTable? I suspect it'll be tons faster!
>
> Thx!

Unfortunately, it is not me who is generating the SQL. We are using a third party tool that sits on top of the DB. It generates this monster....

--Jonathan Received on Wed Oct 30 2002 - 06:47:55 CST