locked
How understanding the execution plan of a query RRS feed

  • Question

  • Hi,

    I need to find a detailed documentation (white papers, articles) about how reading/understanding the execution plan of a query.

    Any suggests to me, please? Thanks

    • Moved by Tom Phillips Monday, June 11, 2012 3:04 PM Query question (From:SQL Server Database Engine)
    Saturday, June 9, 2012 1:35 PM

Answers

  • You might start with Grant Fritchey's book SQL Server Execution Plans.

    You can find many other articles on the subject with an internet search. 


    Dan Guzman, SQL Server MVP, http://weblogs.sqlteam.com/dang/

    • Proposed as answer by Naomi N Sunday, June 10, 2012 4:35 AM
    • Marked as answer by amber zhang Tuesday, June 19, 2012 2:29 AM
    Saturday, June 9, 2012 2:05 PM
  • I use this free tool for easy understand execution plan

    maybe you like to look on it as well

    SQL Sentry Plan Explorer

    • Proposed as answer by Naomi N Sunday, June 10, 2012 4:35 AM
    • Marked as answer by amber zhang Tuesday, June 19, 2012 2:29 AM
    Sunday, June 10, 2012 4:13 AM

All replies