Wednesday, February 15, 2012

Execution plan

Hi
Where can i find the information regarding Optimizing SQL Code by Execution
plan
regards
LaraIt is not as simple as the question sounds. First of all one needs to
understand how to read execution plans, and identify performance issues. And
then based on the information from execution plans, you should be able to
identify the poorly performing queries and rewrite them, or add/remove
required indexes etc.
See if the following help:
http://www.sql-server-performance.c...an_analysis.asp
SQL Server performance tuning books:
http://vyaskn.tripod.com/sqlbooks.htm#perf
--
HTH,
Vyas, MVP (SQL Server)
SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
"Lara" <lara@.hotmail.com> wrote in message
news:u3skw1MyFHA.3152@.TK2MSFTNGP10.phx.gbl...
Hi
Where can i find the information regarding Optimizing SQL Code by Execution
plan
regards
Lara

No comments:

Post a Comment