本文介绍了一种快速估算大型数据库表中行数的方法：使用 sp_spaceused 存储过程，这种方法与直接查询 COUNT(1) 的效果类似，但更高效。需要注意的是，如果表正在更新过程中，则该方法得到的结果可能与实际行数略有出入。
If you want to estimate how many rows in a big table.
You can use this query :
sp_spaceused 'table_name' ,which is same as "select count(1) from table_name with nolock".
The disadvantage of this query is that if the table is being updated.
You just can count the num of rows before it has been updated. It may be a little different with the exact the num.
扫一扫
3666
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
