Skip to main content
Ben Nadel
It's not enough; but, not enough is better than nothing.
Ben Nadel at CFUNITED 2009 (Lansdowne, VA) with: Jeff Coughlin
Ben Nadel at CFUNITED 2009 (Lansdowne, VA) with: Jeff Coughlin@jeffcoughlin )

said okur

Member since Dec 11, 2008

Recent Blog Comments By said okur

  • SQL Optimization Case Study - JOIN Clause vs. IN Clause

    Posted on Sep 24, 2007 at 4:11 PM

    Interestingly I've had the same experience. I used subselects with IN statements thinking it would be much faster because in my case the outer table jas to be joined 3 times and i was thinking it'll scan the table 3 times. It was something like this; select name from names where id in ( creating a l... read more »