said okur
Member since Dec 11, 2008
- Profile: /members/832-said-okur.htm
- Comments: 1
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 »