Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Tue, 06 Nov 2012 @ 17:11:46 GMT

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

Subj:   Re: How DISTINCT and GROUP BY have same performance in TD 14
From:   Anomy Anom

< -- Anonymously Posted: Tuesday, November 06, 2012 11:27 -- >

In TD12 and earlier, DISTINCT used a sort / remove duplicates step at the end while the logically equivalent GROUP BY used an aggregation step.

In TD13.0 and later, the optimizer can essentially rewrite DISTINCT as GROUP BY (or in limited cases, vice versa) when the cost estimate indicates the other method will perform better.

  <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