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