【SQLSERVER】利用showplan_all查看SQL详细执行计划
USE AdventureWorks2012; GO SET SHOWPLAN_ALL ON; GO -- First query. SELECT BusinessEntityID FROM HumanResources.Employee WHERE NationalIDNumber = '509647174'; GO -- Second query. SELECT BusinessEntityID, EmergencyContactID FROM HumanResources.Employee WHERE EmergencyContactID LIKE '1%'; GO SET SHOWPLAN_ALL OFF; GO
本作品采用 知识共享署名-非商业性使用 2.5 中国大陆许可协议进行许可。 |