SQL Server Performance

Interpreting Query Execution Plan

Discussion in 'SQL Server 2005 General Developer Questions' started by umimetha, Apr 9, 2007.

  1. umimetha New Member

    Hi all,

    I know how to get the Query execution plan in graphical form in the SQL server. But it's really useless as I do not know how to interpret it and use it for query optimization.

    It would be highly appreciated if someone can give me the basic guidance onthis or else if I'm informed of a good online tutorial.

    Thanks!
    UMI
  2. DilliGrg Member

    quote:Originally posted by umimetha

    Hi all,

    I know how to get the Query execution plan in graphical form in the SQL server. But it's really useless as I do not know how to interpret it and use it for query optimization.

    It would be highly appreciated if someone can give me the basic guidance onthis or else if I'm informed of a good online tutorial.

    Thanks!
    UMI

    Query execution shows if there are table scans, index scans operation is performed. If the table scan, estimated row count, estimated cost, sort are high, that means you need to revisit your query. Check for indexex, sorting, unnecessary joins etc. The higher the Estimated cost, the worse query performance.



    Thanks,

    Name
    ---------
    Dilli Grg

    (1 row(s) affected)

  3. Luis Martin Moderator

    http://www.sql-server-performance.com/query_execution_plan_analysis.asp

    Also:

    http://www.sql-server-performance.com/advanced_search.asp

    and search: Query execution plan

    Luis Martin
    Moderator
    SQL-Server-Performance.com

    All in Love is Fair
    Stevie Wonder


    All postings are provided “AS IS” with no warranties for accuracy.



  4. umimetha New Member

    Hi,
    Thanks all for your responses. It helpeda lot.
  5. Roji. P. Thomas New Member

  6. MohammedU New Member

  7. satya Moderator

    Umi
    Is it for SQL 2000 or 2005?>

    Satya SKJ
    Microsoft SQL Server MVP
    Writer, Contributing Editor & Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided AS IS with no rights for the sake of knowledge sharing. The greatest discovery of my generation is that a human being can alter his life by altering his attitudes of mind.
  8. dhilditch New Member

    Far and away the BEST book i have ever read for this kind of stuff is T-SQL Querying by Itzik Ben-Gan. It's a must read for this kind of stuff.


    Add flight search to your own site for free
    www.skyscanner.net
  9. DilliGrg Member

    quote:Originally posted by dhilditch

    Far and away the BEST book i have ever read for this kind of stuff is T-SQL Querying by Itzik Ben-Gan. It's a must read for this kind of stuff.


    Add flight search to your own site for free
    www.skyscanner.net


    I agree. I bought this book couple of months ago and it's one of the best book out there.



    Thanks,

    Name
    ---------
    Dilli Grg

    (1 row(s) affected)

  10. satya Moderator

    Iztik, great guy and when you talk to him its always like listening to TSQL [<img src='/community/emoticons/emotion-1.gif' alt=':)' />], had a good discussion during MVP global summit.<br /><br /><b>Satya SKJ</b><br />Microsoft SQL Server MVP<br />Writer, Contributing Editor & Moderator<br /<a target="_blank" href=http://www.SQL-Server-Performance.Com>http://www.SQL-Server-Performance.Com</a><br /><center><font color="teal"><font size="1">This posting is provided AS IS with no rights for the sake of <i>knowledge sharing. <hr noshade size="1">The greatest discovery of my generation is that a human being can alter his life by altering his attitudes of mind.</i></font id="size1"></font id="teal"></center>

Share This Page