Re: Query performance ?

["Jamadagni, Rajendra" <rajendra.jamadagni@ESPN.COM>]

IN or NOT IN is just a better way of writing multiple OR statements, which
in turn is a better way of writing multiple UNION statements (generally
speaking).

If you want to use more than say 10 values for IN clause, create a temp
table, insert values in the table and then use a sub-query, that would be
faster. YMMV.

HTH
Raj
______________________________________________________
Rajendra Jamadagni              MIS, ESPN Inc.
Rajendra dot Jamadagni at ESPN dot com
QOTD: Any clod can have facts, but having an opinion is an art !
Any opinion expressed here is personal and doesn't reflect that of ESPN Inc.