Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Tue, 28 Oct 2003 @ 10:59:37 GMT


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


Subj:   What do the following mean ?
 
From:   Narayan Murthy K S

What do the following mean ?

1. The result goes into Spool 1 (group_amps), which is built locally on the AMPs.

2. We do an all-AMPs RETRIEVE step from CHK.B by way of an all-rows scan with a condition of ("NOT (CHK.B.b IS NULL)") into Spool 2 (all_amps), which is redistributed by hash code to all AMPs.

I am looking for answers to the words {Spool 1(group_amps)} and {Spool 2 (all_amps)}.

Narayan



     
  <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