SQLSERVER 性能优化统计信息

DBCC DROPCLEANBUFFERS --清除缓冲区
DBCC FREEPROCCACHE --删除计划高速缓存中的元素

SET STATISTICS TIME ON
SET STATISTICS IO ON
SET STATISTICS PROFILE ON



-- 执行代码



SET STATISTICS TIME OFF
SET STATISTICS IO OFF
SET STATISTICS PROFILE OFF
GO
 

  

posted @ 2019-09-23 11:06  challengesoflife  阅读(231)  评论(0编辑  收藏  举报