Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
ProEdge
Yak Posting Veteran
64 Posts |
 Posted - 2007-02-13 : 13:09:16
|
| Hi, does anyone know if a T-SQL command exist to generate/create an execution plan for a query? Kind of similar to creating it through Query Anaylzer when you push the button? |
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
Posted - 2007-02-13 : 14:03:37
|
| SET SHOWPLAN_ALL ONorSET SHOWPLAN_TEXT ONCODO ERGO SUM |
 |
|
|
ProEdge
Yak Posting Veteran
64 Posts |
Posted - 2007-02-13 : 18:17:33
|
| Michael, that only sets to show the plan but it doesn't necessarily execute or generate the plans for me. I know I can't seem to find any command like this in the BOL. Maybe a hidden stored procedure or function? |
|
|
|
|
|
|
Execution Plans