7

Is there a SQL Server equivalent to PostgreSQL's EXPLAIN command that I can run on SQL Server 2008 R2 Express (ie. without SQL Profiler)?

ajbeaven
  • 9,265
  • 13
  • 76
  • 121
  • 4
    possible duplicate of [How do I obtain a Query Execution Plan?](http://stackoverflow.com/questions/7359702/how-do-i-obtain-a-query-execution-plan) – shf301 May 03 '13 at 03:55

1 Answers1

6

You should use SET SHOWPLAN_ALL ON before submitting your query to display the execution plan. Do note, though, that it is scheduled to be removed in favour of SHOWPLAN_XML in a future version.

hd1
  • 33,938
  • 5
  • 80
  • 91