I want to know what is difference between count(*), count(id) and count(1) base on performance issues.
We have some quires with count(*) that sometimes throws timeout and we have many Transactions on these tables in our other queries.
we guess that if we change it to count(id) or count(1) it will be better.
Is this change effective?
Any information will be helpful.
Thanks and regards,