Yesterday I published a video One Query Many Plans – SQL in Sixty Seconds #171 and I received lots of questions on the topic.
This episode of SQL in Sixty seconds is very special as it contains 9 SQL SERVER Performance Tuning Tips. The length of the video is also longer.
This video is hosted on SQLPASS youtube channel: Neutralize Troublesome SQL Server Indexes – Fun Stories & Demos. Let us watch it.
Why the result we get is the result we get. The answer is very simple – it is because of the Logical Processing Order of the SELECT Statement.