Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Thu, 11 Sep 2003 @ 09:26:36 GMT


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


Subj:   Re: Teradata Stored Procedures and Cursors
 
From:   Dennis Calkins

Hi,

Teradata is a Parallel architecture and likes doing Mulitple things at the same time. If you apply a Cursor you are SERIALIZING your operation and defeating the strength of Teradata.

Try to see if there is a way to apply the work you are doing by Looping through each row via an SQL statement wich can work across the whole table at once.

If the LOOP is to eliminate some rows from the result, try adding a WHERE clause to eliminate those rows rather than looking at each row individually.

If you are calculating a Mean or STD DEV or somthing like that try one of the built-in Teradata OLAP functions or come V2r5.1 you can define your own UDF which will work inside the parallel nature of teradata



     
  <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