Home Page for the TeradataForum
 

Archives of the TeradataForum

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


     
  <Prev Next>   <<First <Prev
Next>
Last>>
 


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



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