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.



  <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: 28 Jun 2020