Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Wed, 25 Jul 2007 @ 10:53:42 GMT

  <Prev Next>   <<First <Prev

Subj:   Re: MAX vs rank-qualify
From:   Anomy Anom

<-- Anonymously Posted: Tuesday, July 24, 2007 22:19 -->

Thanks Barry and Deiter for your insights.


  The OLAP functions will always redistribute the qualifying rows of the table by values (based on partition and order by clause). The normal aggregate functions can avoid a redistribution if the primary index columns are the same or a subset of the columns that you're using in your "GROUP BY" clause.  

For the case of the OLAP function, does the redistribution happen even when the primary index columns are a subset of the partition by columns (when it shouldnt be logically speaking?) The explain does not take me any near to the answer because the explain only states "is assumed to be redistributed by value to all AMPs"


  <Prev Next>   <<First <Prev
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 15 Jun 2023