Friday, March 9, 2012

Function like Informix DB's Set Explain

Hi,
In SQL Server is any function like Informix DB's Set Explain?
It's mean that during execute SQL syntax and I can know the SQL syntax use
what's kind of Index or not.
So, what's name of this function in SQL Server? And how to run it? Any
document can reference?
Thanks for help!
Angiangi
I think what you need is to look at Show Execution Plan option in the Query
menu on QA.
"angi" <enchiw@.sanrong.com.tw> wrote in message
news:uK5sjN71EHA.1192@.tk2msftngp13.phx.gbl...
> Hi,
> In SQL Server is any function like Informix DB's Set Explain?
> It's mean that during execute SQL syntax and I can know the SQL syntax use
> what's kind of Index or not.
> So, what's name of this function in SQL Server? And how to run it? Any
> document can reference?
> Thanks for help!
> Angi
>|||"angi" <enchiw@.sanrong.com.tw> wrote in message
news:uK5sjN71EHA.1192@.tk2msftngp13.phx.gbl...
> Hi,
> In SQL Server is any function like Informix DB's Set Explain?
> It's mean that during execute SQL syntax and I can know the SQL syntax use
> what's kind of Index or not.
> So, what's name of this function in SQL Server? And how to run it? Any
> document can reference?
> Thanks for help!
> Angi
>
Use the Showplan icon in the Query Analyzer.
A text based option is to run the SET SHOWPLAN ON statement.
Take a look in Books Online for SHOWPLAN option for analyzing query plans.
HTH
Rick Sawtell
MCT, MCSD, MCDBA|||Thanks Uri Dimant and Rick Sawtell.
Thank you so much!
Angi

No comments:

Post a Comment