MySQL explain statement in MS-SQL

Hi experts

is there something similar like the MySQL Explain statement in MS-SQL?
I know there the MS Query Analyzer, which is only part of the enterprise management studion. Unfortunately I don't have a that.

Thanks
LVL 3
ArikaelAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
Guy Hengel [angelIII / a3]Connect With a Mentor Billing EngineerCommented:
in MS SQL QA, you have the "show estimated execution plan" to show the estimate (without running the query)
in MS SQL QA, you have the "show execution plan" to show the estimate (will show the effective ep after running the query)

in ms sql management studio, you have the same things, only the second one is called "included execution plan".
0
 
ArikaelAuthor Commented:
That was quick and very helpful. Thanks
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.