I was reading an SQL tutorial which used the keyword EXPLAIN to see how a query is executed. I tried it in SQL Server 2008 with no success.
How do I get the equivalent result?
4 Answers
In SSMS (I got 18.3.1) highlight the query in question and hit CTRL+L
(that does what Tobias mentioned - Query->Display Estimated Query Plan)
Related