SQL Server Performance Forum – Threads Archive

Interpreting Query Execution Plan

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

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)

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.

Hi,
Thanks all for your responses. It helpeda lot.

BOL can also be very helpful on this. Roji. P. Thomas
SQL Server MVP
http://toponewithties.blogspot.com

SQL Server 2005 Books Online
Displaying Graphical Execution Plans (SQL Server Management Studio)
http://msdn2.microsoft.com/en-us/library/ms178071.aspx Check the following blog…
http://blogs.msdn.com/sqlqueryprocessing/archive/tags/SQL Server 2005/default.aspx
MohammedU.
Moderator
SQL-Server-Performance.com All postings are provided â€œAS ISâ€ with no warranties for accuracy.

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.

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

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)

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. Satya SKJ Microsoft SQL Server MVP Writer, Contributing Editor & Moderator http://www.SQL-Server-Performance.Com</a> <center>This posting is provided AS IS with no rights for the sake of 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.</center>

]]>