Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Mon, 04 Apr 2005 @ 14:50:11 GMT

  <Prev Next>  
Next> Last>>  

Subj:   OLAP functions "assume to redistribute" ?!?
From:   Mirjam Berger


I need some help on what is going on in the OLAP functions.

Every time I use an OLAP function I get a step in the explain like:

     8) We do an all-AMPs STAT FUNCTION step from Spool 2 (Last Use)
        by way of an all-rows scan into Spool 9 (Last Use), which is
        assumed to be redistributed by value to all AMPs.  The result
        rows are put into Spool 1 (group_amps), which is built locally
        on the AMPs.

What is going on here? Why the two spool files? From (2) over (9) into (1)? And what really, really confuses me is the phrase:

     "which is assumed to be redistributed "

Assumed to be redistributed? Assumed? Or Redistributed?

I have looked through the doku for anything providing more info on this, but I can't find anything.

ANY knowledgable input on this would be highly appreciated!!!


Mirjam Berger

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