September 20, 2011 at 10:20 pm
HI all
Please let me know hoe internelly set of query which has 3-4 joins and many where condition query will get execute .
says that from right to left it will get execute , let me knoe in detail
how actually it will get excecute .
Thanks In Advance
Ravi.
September 20, 2011 at 10:53 pm
Please check out the BOL topics from the link below. If this is not sufficient then I suggest that you buy one of the Inside SQL Server books. There are also many whitepapers in MSDN & Technet that goes into details on specific areas like compilation, stats, etc.
September 20, 2011 at 10:55 pm
Open or type a Transact-SQL script that contains the queries you want to analyze into the Management Studio query editor. After the script has been loaded into the Management Studio query editor, you can choose to either display an estimated execution plan or the actual execution plan by clicking the Display Estimated Execution Plan or the Include Actual Execution Plan button on the query editor toolbar
Read from this link:
http://msdn.microsoft.com/en-us/library/ms178071.aspx
You may also refer this book which is available in PDF (free).
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply