turn on/off statistics in SQL Server

最新推荐文章于 2024-09-15 23:28:35 发布

alien1

最新推荐文章于 2024-09-15 23:28:35 发布

阅读量167

点赞数

文章标签： sql

SET STATISTICS IO,TIME ON;

SET STATISTICS TIME,IO OFF;

Table 'TBL_SAMPLE_WITH_NULL'. Scan count 1, logical reads 2982, physical reads 0, read-ahead reads 16, lob logical reads 0, lob physical reads 0, lob read-ahead reads 0.

 SQL Server Execution Times:
   CPU time = 187 ms,  elapsed time = 192 ms.

SET SHOWPLAN_TEXT ON

SET SHOWPLAN_TEXT OFF

|--Index Seek(OBJECT: ([tempdb].[dbo].[TBL_SAMPLE_WITH_NULL].[NCLIDX_DBO_TBL_SAMPLE_WITH_NULL_FLAG] AS [SWN]), SEEK: ([SWN].[FLAG]=NULL) ORDERED FORWARD)

ref to https://www.sqlservercentral.com/Forums/Topic1717628-391-1.aspx