Error!
Success!

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

0
kicks

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

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.


Kicked By:
Drop Kicked By: