SQL Server - Count(*) or Count(1) ? - Which is better?

added by ashish.gilhotra
8/5/2010 1:00:52 PM

13 Kicks, 859 Views

Every so often on the on-line forums, the question of : Which is better Count(*) or Count(1) ? will occur. So can it categorically be proved than one is better than the other ? What we need to do is populate a table and use both count(*) and count(1) and see if we get any performance difference between the two.