John Varady
Member since Dec 11, 2008
- Profile: /members/738-john-varady.htm
- URL: http://www.jabberwonk.com
- Comments: 1
Recent Blog Comments By John Varady
-
SQL IN Directive Much Faster Than Multiple OR Clauses
Posted on Jul 27, 2008 at 4:32 PM
Ben, The "1=1 OR" in your where cause will return ALL records and probably explains the large difference in the run times. I'm sure the IN is faster than multiple OR's anyway, but probably not to the degree that your test showed.... read more »