John Bevilaqua
Member since Sep 2, 2011
- Profile: /members/8916-john-bevilaqua.htm
- Comments: 1
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 the INNER ... read more »