SET SHOWPLAN_TEXT ON;
GO
SET SHOWPLAN_ALL ON;
GO
SELECT * FROM YOUR_TABLE;
GO
SET SHOWPLAN_ALL OFF;
GO
SET SHOWPLAN_TEXT OFF;
GO

引用: https://bit.ly/2RAQ1mk