Archives of the TeradataForum
Message Posted: Thu, 24 Jun 2004 @ 07:53:16 GMT
| Subj: | | Re: Performance of COUNT(Integer Constant) over COUNT(*) |
| |
| From: | | David Clough |
Kambhoji, Naveen Ram Prasanna wrote :
| | Is there any performance gain in COUNT(Integer Constant) over COUNT(*)... If not so any specific use of using count(1) over count(*).How
does count(*) and count(1) are calculated internally. | |
I'm also looking at this issue, but can find no difference between the two constructs in terms of performance. Certainly would be interested
in others' comments.
One suggestion I heard - albeit from an Oracle background - was that Count(1) used the statistics rather than from the table data, although I'm
pretty sure that's nonsense.
Regards,
Dave Clough
Database Designer
Database Design Group
| 
