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.
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
- Thread starter csup
- Start date
- Status
Similar threads
- Locked
- Question
- Locked
- Question