MS SQL equivalent of Oracle explain plan to optimize a query

Hello,

I have some Crystal SQL command object reports which need to be optimized to run on a huge MS SQL Server database.  The reports take too long to run.  I know how to use the Oracle Explain plan utility to see the statistics of the query load on the database.  Is there a similar MS SQL utility which will help me determine how to modify my queries for optimum performance (to run faster).  Thank you in advance for your input.
jrbledsoe001Asked:
Who is Participating?
 
skullnobrainsConnect With a Mentor Commented:
SET STATISTICS PROFILE

SET SHOWPLAN_TEXT
SET SHOWPLAN_ALL

showplan is the equivalent of exec plan in oracle

obviously each SGBD provides very different output and you probably will not understand all the output without going through some documentation
0
 
mlmccCommented:
Even though these are Crystal commands the topic area should be just MS SQL Server

Deleted
Crystal Reports
MY SQL

mlmcc
Zone Advisor
0
 
jrbledsoe001Author Commented:
Thank you.  This is exactly what I needed!!!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.