sql server Count() 速度纪录

测试表中有六百五十八万九千多条数据

 ID：主键

UUID：非聚集索引

数据量：

 

1. select COUNT(*) from [Chapter]

 

 

 

2. select COUNT(ID) from [Chapter]

 

 

3.  select COUNT(UUID) from [Chapter]

 

 

 4. select COUNT(1) from [Chapter]

 

5.  select COUNT(*) from [CrawlerFiction].[dbo].[Chapter] with(nolock)

 

 6. select COUNT(*) from [CrawlerFiction].[dbo].[Chapter] with(readpast)

 

posted @ 2020-05-21 15:08  Vaynedy  阅读(231)  评论(0)  编辑  收藏  举报