Anil Konanki
Member since Jul 19, 2010
- Profile: /members/6445-anil-konanki.htm
- URL: http://None
- Comments: 1
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 »