Community Member Profile
Anil Konanki
Member since Jul 19, 2010
- Profile: /members/6445-Anil-Konanki.htm
- URL: None
- Comments: 1
- Points: 11
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... read more »
