SQL Programming: Understanding the Logical Order of Operations in SELECT statements

There are number of ways in which the most basic elements of SQL code can be constructed to ensure good processing performance. The best way to tune performance is to try to write your queries in a number of different ways and compare their reads and execution plans. Sometimes the reason for the slow response time is due to the fact that the query is not written to perform as efficiently as possible. Following is the order in which SQL elements get executed as this will change the way we can optimize SELECT queries: FROM Clause ON OUTER WHERE...

Read More