Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Mon, 14 Nov 2005 @ 20:05:32 GMT


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


Subj:   Re: Stored procedures results
 
From:   Eric Friedman

  This penalty is much like the penalty paid for doing an ORDER BY in Teradata, which has to be done in one AMP.  


  Absolutely not true. All AMPs locally order rows; the final merge is done by BYNET/PE in the course of returning the answer set to the client.  


I stand corrected about where the final ORDER BY processing is being done. Nevertheless, the point remains that the final ORDER BY is necessarily a serial, not parallel, process being done by one component before the results are returned. This is identical in concept to the serial process of assembling the local results of a SP executed in parallel locally by each processor.

There is no reason (at least in Oracle) why most of the heavy lifting in a SP cannot be done in parallel if the SP is properly written to take advantage of parallelism. The same should be even more true for Teradata's massively parallel architecture.


Eric Friedman



     
  <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: 15 Jun 2023