How understanding the execution plan of a query
-
sábado, 9 de junho de 2012 13:35
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
- Movido Tom PhillipsModerator segunda-feira, 11 de junho de 2012 15:04 Query question (From:SQL Server Database Engine)
Todas as Respostas
-
sábado, 9 de junho de 2012 14:02
Pscorca,
Execution plan are the roadmaps for the query to be followed by Server while processing Sql queries. The following links will help you understand the basic and advance of execution plans.
- http://www.simple-talk.com/sql/performance/execution-plan-basics/
- http://www.mssqltips.com/sqlservertip/1856/sql-server-query-execution-plans-in-sql-server-management-studio/
- The difference between Actual and Esitmated execution plan is very well explained by Pinal Dave , please follow http://blog.sqlauthority.com/2007/08/28/sql-server-actual-execution-plan-vs-estimated-execution-plan/
Thanks
Manish
Please use Mark as Answer if my post solved your problem and use Vote As Helpful if a post was useful.- Sugerido como Resposta Aalam Rangi domingo, 10 de junho de 2012 07:52
-
sábado, 9 de junho de 2012 14:05
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/
- Sugerido como Resposta Naomi NMicrosoft Community Contributor, Moderator domingo, 10 de junho de 2012 04:35
- Marcado como Resposta amber zhangModerator terça-feira, 19 de junho de 2012 02:29
-
sábado, 9 de junho de 2012 16:01The suggestions made are very good. Another execllent source is SQL Server Books Online - there is an option to install with the SQL server
Jack Vamvas sqlserver-dba.com
-
domingo, 10 de junho de 2012 04:13
I use this free tool for easy understand execution plan
maybe you like to look on it as well
- Sugerido como Resposta Naomi NMicrosoft Community Contributor, Moderator domingo, 10 de junho de 2012 04:35
- Marcado como Resposta amber zhangModerator terça-feira, 19 de junho de 2012 02:29
.png)
