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

Dave Hoogendoorn

Member since Sep 10, 2009

Recent Blog Comments By Dave Hoogendoorn

  • SQL Optimization And ON Clause vs WHERE Clause

    Posted on Sep 10, 2009 at 5:21 AM

    Although performance seems the same, the query with the older SQL 89 syntax is more costly. So it's more about I/O (table access). If you have a fast server, differences can be minor. On a busy or slow server, use the SQL 92 syntax though.... read more »