October 25, 2010 at 1:37 pm
Can some one help me in understanding the execution plan of a storedproc
i have created a sp and had the execution plan for it as i never used it before i understood nothing of that plan,
can you say me how to analyse the plan ??
October 25, 2010 at 2:14 pm
There are a few key things to look for in any execution plan. The first is any warnings on it. These will usually be marked in red and highly visible.
The next is to mouse-over the nodes on the plan, and see what SQL Server is doing in each place. That's how you'll find index/table scans, which are another key thing to look for. It's also where you'll find other important details.
That's how you start. Beyond that, you read up on execution plans, or you post the plan on a site like this one and see if others can help you on it.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
October 25, 2010 at 2:42 pm
http://www.sqlservercentral.com/articles/books/65831
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply