Community Member Profile
Dave Hoogendoorn
Member since Sep 10, 2009
- Profile: /members/4283-Dave-Hoogendoorn.htm
- URL: www.sqlperformance.nl
- Comments: 1
- Points: 11
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 »
