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

> 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.

Thanks for the help, it has all been enlightening. -=Cliff Received on Wed Aug 09 2006 - 14:31:20 CDT