Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

SHOWPLAN ALL

Status
Not open for further replies.

csup

Programmer
Feb 26, 2011
2
US
I have executed the showplan_all statement to look how my select statements will execute using indexes, etc. I got the information in the results pane but i am having trouble copying it to an excel sheet( or some other format) to analyze. One other thing, I want to look for IO, CPU, RowSize, Cost but these columns are not in my results output. There are many other columns in the results but not the above. Can anyone help me with this? Thank you in advance.

I've tried to attach a file of a gif image but does not work.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top