execution plan

hi
anybody tell me, how to get execution plan in T SQL to
text file.
thanks
kalyan
..
Kalyan wrote:
> hi
> anybody tell me, how to get execution plan in T SQL to
> text file.
>
> thanks
> kalyan
> .
From QA, SET STATISTICS PROFILE ON
Output to text format
Run SQL
Save the Results
David Gugick
Imceda Software
www.imceda.com
|||Well, you have a clustered index defined on the table by query optimizer was
not able to use it (clustered index scan)
See why it has happened? Don't use SELECT * in your code ,take advantage of
using COVEREd indexes.
For more details please refer to the BOL
"Robert Lie" <robert.lie24@.gmail.com> wrote in message
news:un8KquSUFHA.3008@.TK2MSFTNGP10.phx.gbl...
> Dear All,
> Pls take a look at the attached picture.
> I want to tune up the performance of the query.
> So What should I do?
> -By using Update Statistic on the policy table OR
> -By executing DBCC DBREINDEX statement on the policy table
> Please give me some further explanantion.
> Thanks
> Robert Lie
>