View plan

In SQL Query editor window you can click on either:

• Display Estimated Execution Plan ()
• Include Actual Execution Plan ()

You can also see history of executions:

SELECT t.[text]
FROM sys.dm_exec_cached_plans AS p
CROSS APPLY sys.dm_exec_sql_text(p.plan_handle) AS t
WHERE t.[text] LIKE N'%something unique about your query%';