Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Thu, 27 Mar 2008 @ 20:40:44 GMT


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


Subj:   Re: How GROUP BY improves the performance than
 
From:   Mutsch, Joerg

Hi Ravikumar,

Group by is less costly if you have multiple distinct values with lots of records for each value.

Distinct is less costly if the number or rows per distinct value are quite low or even unique.


Cheers

Joerg



     
  <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: 23 Jun 2019