Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Sun, 05 Dec 2004 @ 16:13:08 GMT


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


Subj:   Why is Group-by Faster than Distinct
 
From:   Anomy Anom

<-- Anonymously Posted: Sunday, December 05, 2004 10:48 -->

Is it a standard optimization technique now to use Group by instead of Distinct to optimize queries that need to remove duplicate records?

Is there any difference in results, in case I am going to use group by instead of distinct? If there is no difference why doesn't the optimizer use the duplicate removal operation which is faster in Group by instead of the one that is use in distinct?


Thanks in advance.



     
  <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