????3????????????????????????where????????like??????????????????????????ctrl+alt+a????????????????????????????????

????4??????????Optimize for Ad hoc Workloads???1??

 EXEC sp_configure 'optimize for ad hoc workloads'?? 1
RECONFIGURE
GO

????5?????????????棺

DBCC FREEPROCCACHE
GO

????6???????????

USE AdventureWorks
GO
SELECT  *
FROM    Sales.SalesOrderDetail
WHERE   SalesOrderDetailID = 43659
GO

????7?????????????????????????μ???????

SELECT  CP.usecounts AS CountOfQueryExecution ??
        CP.cacheobjtype AS CacheObjectType ??
        CP.objtype AS ObjectType ??
        ST.text AS QueryText
FROM    sys.dm_exec_cached_plans AS CP
        CROSS APPLY sys.dm_exec_sql_text(plan_handle) AS ST
WHERE   CP.usecounts > 0
        AND ST.text LIKE '%SELECT  *  FROM    Sales.SalesOrderDetail  WHERE   SalesOrderDetailID = 43659  %'
        AND CP.cacheobjtype = 'Compiled Plan'
GO