Execution Plan Query's

how to save or allocate execution plan sql server...?
Atte.,
Carlo
On Apr 11, 9:50 am, "Carlo" <csor...@.hotmail.com> wrote:
> how to save or allocate execution plan sql server...?
> Atte.,
> Carlo
If I understand your question correctly do you mean how to save the
execution plan to a file?
in 2005 hit CTRL + M run your query. then File-->Save execution Plan
As
in SQL 2000 use SET SHOWPLAN_TEXT ON then copy and paste the output
however this will not always work
select * from sysobjects --will work
--sp_who2 --will not work
Denis the SQL Menace
http://sqlservercode.blogspot.com/
Denis the SQL Menace
http://sqlservercode.blogspot.com/
|||sorry my bad english..., my question is into SQL SERVER...
Atte.,
Carlo
"SQL Menace" <denis.gobo@.gmail.com> escribi en el mensaje
news:1176301089.781303.162640@.q75g2000hsh.googlegr oups.com...
> On Apr 11, 9:50 am, "Carlo" <csor...@.hotmail.com> wrote:
> If I understand your question correctly do you mean how to save the
> execution plan to a file?
> in 2005 hit CTRL + M run your query. then File-->Save execution Plan
> As
> in SQL 2000 use SET SHOWPLAN_TEXT ON then copy and paste the output
> however this will not always work
> select * from sysobjects --will work
> --sp_who2 --will not work
>
> Denis the SQL Menace
> http://sqlservercode.blogspot.com/
>
> Denis the SQL Menace
> http://sqlservercode.blogspot.com/
>
|||What would you like to do with this plan, when it is in SQL Server. Do you want to store the plan
permanently so that plan should be used on subsequent executions? If so, check out "plan guides",
new for SQL Server 2005.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Carlo" <csorrel@.hotmail.com> wrote in message news:uv5cxaEfHHA.1244@.TK2MSFTNGP04.phx.gbl...
> sorry my bad english..., my question is into SQL SERVER...
> Atte.,
> Carlo
> "SQL Menace" <denis.gobo@.gmail.com> escribi en el mensaje
> news:1176301089.781303.162640@.q75g2000hsh.googlegr oups.com...
>