Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Wed, 11 Dec 2002 @ 10:39:36 GMT


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


Subj:   Count(*) and DELETE *
 
From:   Barham, William

How is it that a count(*) may take a long time to return a value but delete * will act immediately and tell you how many rows there were?

Are there different counting mechanisms at work here and, if so, why doesn't count use the same mechanism as the delete?

Bill



     
  <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