Difference between COUNT (1), COUNT (1000), COUNT (*).

SELECT COUNT(1000) FROM employee

SELECT COUNT(1) FROM employee

SELECT COUNT(*) FROM employee

All the above queries will give you the same result i.e total no of
rows in the table . Execution Plan for all the above queries are same.

Hence , there is no performance difference between the above three.

Pawan Kumar

Pawankkmr@hotmail.com

Advertisements