Subject | COUNT(*) versus COUNT(primary_key) |
---|---|
Author | Robert DiFalco |
Post date | 2003-04-30T17:35:03Z |
In the case where these are functionally equivalent, is there any
performance difference between the two that I should be aware of? I've
only ever seen COUNT(*) used but for my parser, it is a little easier to
generate a COUNT(pkey) when creating select statements based on objects.
R.
[Non-text portions of this message have been removed]
performance difference between the two that I should be aware of? I've
only ever seen COUNT(*) used but for my parser, it is a little easier to
generate a COUNT(pkey) when creating select statements based on objects.
R.
[Non-text portions of this message have been removed]