Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Thu, 24 Jun 2004 @ 07:53:16 GMT

  <Prev Next>   <<First <Prev

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.


Dave Clough
Database Designer
Database Design Group

  <Prev Next>   <<First <Prev
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 23 Jun 2019