Community Member Profile
Benjamin Lotter
Member since Jul 20, 2010
- Profile: /members/6453-Benjamin-Lotter.htm
- URL: sqlkit.blogspot.com
- Comments: 1
- Points: 12
Recent Blog Comments By Benjamin Lotter
-
SQL Optimization And ON Clause vs WHERE Clause
Posted on Jul 20, 2010 at 3:58 PM
Recently I took a query running 7 minutes down to 2 minutes by moving filter items in the WHERE clause to their corresponding ON clauses. In my case, there are 6 inner joins with 2 of them being to derived tables. Personally I prefer to keep JOIN logic in the ON clause and filter logic the WHER... read more »
