SQL:  How to Create an Explain Plan

TBSupport
TBSupport used Ask the Experts™
on
Hello:

How do you create an explain plan (.sqlplan file) for a T-SQL query?

TBSupport
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Top Expert 2012
Commented:
Query | Include Execution Plan menu
Query | Execute menu
Click on Execution plan tab
File | Save Execution Plan As ... menu.

Author

Commented:
Is there a way to do this, without having to run the SQL query?  The query has been running for four hours, now.

TBSupport

Author

Commented:
Disregard....I figured it out.  Thanks, for your help!

TBSupport

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial