22,209
社区成员
发帖
与我相关
我的任务
分享
set statistics io on
set statistics time on
select * from dbo.tblbjcpjjb WHERE ID=381688
DBCC DROPCLEANBUFFERS
GO
DBCC FREEPROCCACHE
GO
SET STATISTICS IO ON
SET STATISTICS TIME ON
GO
SELECT *
FROM dbo.tblbjcpjjb
WHERE ID = 381688
GO
SET STATISTICS IO OFF
SET STATISTICS TIME OFF
GO
set statistics io on
--使 SQL Server 显示有关由 Transact-SQL 语句生成的磁盘活动量的信息。
set statistics time on
--显示分析、编译和执行各语句所需的毫秒数。
缓存这方面可以看ms技术内幕T-SQL查询 这本书。网上下个看看
DBCC DROPCLEANBUFFERS
DBCC FREEPROCCACHE