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

Anil Konanki

Member since Jul 19, 2010

Recent Blog Comments By Anil Konanki

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

    Posted on Jul 19, 2010 at 3:21 PM

    I was with the belief that an IN condition is better than a JOIN condition. But today, I came across a scenario where the JOIN condition performed better than IN. To add to my woes, the IN condition and the JOIN condition both retrieve only 9 rows. The cost of the query where IN was used is less... read more »