Friday, March 23, 2012

query plan

I ran a sql query plan on query analizer, I need to send to someone by
email.
How do I send a query plan?
Thanksyou can take a snapshot of the query using "Print Screen"
button of the keyboard and generating bmp file out of it.
note: you will have an option to zoom in and zoom out the
image of "graphical query plan". you will get this by
right clicking on the "execution plan" pane.
Or you can send the textual outupt of the "query plan" by
turning on the option "SHOWPLAN_ALL". And the generated
output can be saved in TEXT file.
Ex:
USE pubs
GO
SET SHOWPLAN_ALL ON
GO
SELECT au_id
FROM authors
WHERE au_id = '409-56-7008'
GO
- Vishal
>--Original Message--
>I ran a sql query plan on query analizer, I need to send
to someone by
>email.
>How do I send a query plan?
>Thanks
>
>.
>sql

No comments:

Post a Comment