[MSSQL]Select count(*)与Select count(字段)的效率分析

最新推荐文章于 2024-08-20 14:56:43 发布

厦门德仔

最新推荐文章于 2024-08-20 14:56:43 发布

阅读量3.2k

点赞数

分类专栏： MSSQL 文章标签： sql server statistics null application table query

MSSQL 专栏收录该内容

293 篇文章 11 订阅 ¥99.90 ¥299.90

订阅专栏

超级会员免费看

本文分析了在SQL Server中使用COUNT(*)和COUNT(columnname)进行行计数的效率，揭示了COUNT(*)并不一定比COUNT(columnname)慢的误解，并解释了SQL Server内部数据处理原理。通过实例展示了在不同情况下两者的表现，强调在某些场景下，COUNT(*)甚至能利用索引来提高性能。同时提醒开发者，根据实际需求选择合适的计数方式，防止因列值允许NULL导致的错误结果。

摘要由CSDN通过智能技术生成

原文：

Advice on using COUNT( )
In the SQL Server community, one thing that I sometimes encounter is the question on whether you should use COUNT(*) or COUNT(columnname), where columnname is a column in the table that you want to count the rows for. Often the advice given to people in forums and mailing lists is that COUNT(columnname) will perform better than COUNT(*). This is not always the correct advice though, in many cases it is even entirely wrong. Although there are situations where you can (or even should) use COUNT(columnname), you definitely shouldn't always use it. This incorrect piece of advice is probably based on a lack of understanding of how SQL Server handles data internally.

Description of COUNT( )
The first thing tha

了解本专栏