Clear SQL Server data cache and execution plan cache, and view the comparison of execution plans

Clear data and execution plan cache:

DBCC DROPCLEANBUFFERS
DBCC FREEPROCCACHE

Open statistics:

SET STATISTICS IO ON

SET STATISTICS TIME ON

Open the execution plan:

SET
SHOWPLAN_TEXT ON
SET
SHOWPLAN_ALL ON
SET
STATISTICS PROFILE ON
SET
SHOWPLAN_XML ON
SET
STATISTICS PROFILE XML

Differences between options
	Command	Execute Query?	Include Estimated Row Counts & Stats	Include Actual Row Counts & Stats
Text Plan	SET SHOWPLAN_TEXT ON	No	No	No
	SET SHOWPLAN_ALL ON	No	Yes	No
	SET STATISTICS PROFILE ON	Yes	Yes	Yes
XML Plan	SET SHOWPLAN_XML ON	No	Yes	No
	SET STATISTICS PROFILE XML	Yes	Yes	Yes