What is the difference between count(1) and count(*) ?
There is no difference between count (1) and count (*). The best way to prove it compares the execution plan for listed query.
Select Count (1) From [Table_Name]
Select Count (*) From [Table_Name]
Both the query have same execution plan. In both the above query following things happens
This shows that the both query execute in same manner. Both perform same task uses same amount of memory and must execute in same amount of time.
Please login to post your valuable comments.
Get the latest vLemonn news first