SQL COUNT(*) Vs COUNT(column_name)

Samrat Banerjee

Rate me:

4.00/5 (5 votes)

30 Apr 2010CPOL

37.8K

In many case we need to use COUNT function, but always we prefer COUNT(column_name) in placeof COUNT(*) and reason behind that COUNT(column_name) will perform better or faster than COUNT(*).Is this correct?SQL Server can't read just the contents of a single column without reading the...

Revisions

Compare	Revision	Minor	Date	Status	Editor
	2 - publicly available	No	30-Apr-10 22:48	Available	Samrat Banerjee

	1	No	30-Apr-10 22:44	Composing

License

This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Written By

Samrat Banerjee

Software Developer (Senior)

India

Hi, I am Samrat Banerjee from India.
I am a Software Engineer working in .net platform.
I love to explore new technologies.

SQL COUNT(*) Vs COUNT(column_name)

Revisions

License

Comments and Discussions