Skip to main content
Ben Nadel
On User Experience (UX) Design, JavaScript, ColdFusion, Node.js, Life, and Love.

John Bevilaqua

Member since Sep 2, 2011

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 »