Execution Plane Analysis

microsoft.public.sqlserver.programming

1 Jul 2005 7:40 AM

DMP

Hi,
Can Any one give me the reference of an article or web site from where I can
get the proper idea about Execution Plane Report ?

1 Jul 2005 11:17 AM

Rick Sawtell

"DMP" <debdulal.mahapa***@fi-tek.co.in> wrote in message
news:OSAJqAhfFHA.572@TK2MSFTNGP15.phx.gbl...
> Hi,
> Can Any one give me the reference of an article or web site from where I
can
> get the proper idea about Execution Plane Report ?
>
>
>

The Books Online has a pretty good dialog on the subject.

Under the Contents Tab->Optimizing Database Performance\Query
Tuning\Analyzing a Query

Check out the whole Query Tuning section.

Then go read through as much as you can handle at
www.sql-server-performance.com

HTH

Rick Sawtell
MCT, MCSD, MCDBA