Community Member Profile
Ron Cash
Member since Jun 2, 2011
- Profile: /members/8421-Ron-Cash.htm
- Comments: 1
- Points: 9
Recent Blog Comments By Ron Cash
-
SQL Optimization And ON Clause vs WHERE Clause
Posted on Jun 2, 2011 at 3:37 PM
Did not have time to read all the responses, so not sure if this was added. In SQL Server the query engine always executes where clauses first, so don't think it would make much diff. in an on clause. However, if you use a sub query with a where clause to substiute for the table with the where... read more »
