测试表:
表名:Chapter
ID:主键
UUID:非聚集索引
数据量:660万条
结论:速度最快的写法:
select COUNT(*) from [Chapter] with(nolock)
测试记录:
sql | 时间(秒) |
---|---|
select COUNT(*) from [Chapter] | 25 |
select COUNT(ID) from [Chapter] | 18 |
select COUNT(UUID) from [Chapter] | 26 |
select COUNT(1) from [Chapter] | 24 |
select COUNT(*) from [Chapter] with(nolock) | 3 |
select COUNT(*) from [Chapter] with(readpast) | 7 |