Community Member Profile
Drew
Member since May 21, 2010
- Profile: /members/6080-Drew.htm
- Comments: 1
- Points: 9
Recent Blog Comments By Drew
-
SQL Optimization Case Study - JOIN Clause vs. IN Clause
Posted on May 21, 2010 at 1:32 PM
IN vs. EXISTS performance can vary depending on the size and indexing of both the outer and inner tables. Also a neat behavior of EXISTS is that it only needs to find one row that matches then it can stop looking. For example, this will return a 0 or 1 (in Oracle - good "row_exists" function):<... read more »
