Community Member Profile
John Bevilaqua
Member since Sep 2, 2011
- Profile: /members/8916-John-Bevilaqua.htm
- Comments: 1
- Points: 10
Recent Blog Comments By John Bevilaqua
-
SQL Optimization And ON Clause vs WHERE Clause
Posted on Sep 2, 2011 at 10:13 AM
Writing the code with 4 Equi-Joins followed immediately by only the WHERE clause statements applicable to the current Equi-Join was palpably slower than the optimized alternative: Creating 4 INNER JOINS, eliminating most of the WHERE clauses and listing the remaining ones at the bottom of th... read more »
