Text version of execution plan?  
Author Message
ayoung





PostPosted: Mon Nov 22 17:11:39 CST 2004 Top

SQL Server Developer >> Text version of execution plan?

Hello gang --

Is there a way to produce a 'text' version of the graphical execution plan; specifically,
the information that appears in the light yellow 'tool tip' window when you hover over one
of the execution plan icons?

Here's why:
I need to tune one of my stored procedures, and I don't know exactly where to begin. Every
table is indexed as much as it needs to be (as far as I can tell), and I'm still getting a
table scan on a large table. I would like to post details from the execution plan, but I
am not going to post little bitmap images (even if I could figure out how to take a
snapshot of the tool tip text) and invite the well-deserved collective wrath of the group.
Unfortunately, the only other option I know of is to re-type all information in the entire
tool-tip window. Be still my beating heart . . .

As always, any help/advice/suggestions are appreciated.

Thanks in advance --

Carl Imthurn

SQL Server73  
 
 
Adam





PostPosted: Mon Nov 22 17:11:39 CST 2004 Top

SQL Server Developer >> Text version of execution plan? Carl,

Try this:


SET SHOWPLAN_ALL ON
GO

SELECT *
FROM Pubs..Authors


--
Adam Machanic
SQL Server MVP
http://www.sqljunkies.com/weblog/amachanic
--




> Hello gang --
>
> Is there a way to produce a 'text' version of the graphical execution
plan; specifically,
> the information that appears in the light yellow 'tool tip' window when
you hover over one
> of the execution plan icons?
>
> Here's why:
> I need to tune one of my stored procedures, and I don't know exactly where
to begin. Every
> table is indexed as much as it needs to be (as far as I can tell), and I'm
still getting a
> table scan on a large table. I would like to post details from the
execution plan, but I
> am not going to post little bitmap images (even if I could figure out how
to take a
> snapshot of the tool tip text) and invite the well-deserved collective
wrath of the group.
> Unfortunately, the only other option I know of is to re-type all
information in the entire
> tool-tip window. Be still my beating heart . . .
>
> As always, any help/advice/suggestions are appreciated.
>
> Thanks in advance --
>
> Carl Imthurn
>


 
 
Deepak





PostPosted: Mon Nov 22 17:23:04 CST 2004 Top

SQL Server Developer >> Text version of execution plan? Carl,

Use this statement before your query

SET SHOWPLAN_TEXT ON

Regards,

Deepak
[I Code, therefore I am]



> Hello gang --
>
> Is there a way to produce a 'text' version of the graphical execution plan; specifically,
> the information that appears in the light yellow 'tool tip' window when you hover over one
> of the execution plan icons?
>
> Here's why:
> I need to tune one of my stored procedures, and I don't know exactly where to begin. Every
> table is indexed as much as it needs to be (as far as I can tell), and I'm still getting a
> table scan on a large table. I would like to post details from the execution plan, but I
> am not going to post little bitmap images (even if I could figure out how to take a
> snapshot of the tool tip text) and invite the well-deserved collective wrath of the group.
> Unfortunately, the only other option I know of is to re-type all information in the entire
> tool-tip window. Be still my beating heart . . .
>
> As always, any help/advice/suggestions are appreciated.
>
> Thanks in advance --
>
> Carl Imthurn
>
>
 
 
Carl





PostPosted: Mon Nov 22 17:37:48 CST 2004 Top

SQL Server Developer >> Text version of execution plan? Thanks to both of you - that was what I needed.

Appreciate your time and expertise.

Carl