Skip to main content
Ben Nadel
On User Experience (UX) Design, JavaScript, ColdFusion, Node.js, Life, and Love.

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 »