jwcolby
jwcolby at colbyconsulting.com
Tue May 15 21:41:23 CDT 2007
I am processing a query where a set of N fields have any value, AND one
specific field has an IN() clause, i.e. a ton of codes possible.
Is it more efficient to build up a pair of queries, SELECT PKID from tblX
WHERE FldA in('A','B'...), and another query where the "OR" fields are
gathered? Or just use one big query? I hate to even press the button... I
am having to test with a TOP 100 kind of thing as it is.
John W. Colby
Colby Consulting
www.ColbyConsulting.com