Re: Why is using Select in IN() clause much slower than using values?

cliffliang_at_gmail.com wrote:
> > Well, that seems to be quite a view.
> Yes, the joys of working with vendor supplied code and not knowing how
> far to hack around it before going into "unsupported" territory.
>
> > If the list is going to be static, you may
> > be better off with literals.
> This is what I'll go with. The plan on it has the nested loops cut out.
>

I just thought ... if the query with literal list is really 3 times faster and you need some flexibility for the IN list, building the query dynamically with the literal and then executing it might be a solution ... ?

best,
Martin Received on Wed Aug 09 2006 - 15:19:56 CDT