Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Mon, 26 Jan 2009 @ 15:29:52 GMT


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


Subj:   While Loop Performance
 
From:   Linda_Wood

Hello,

We are converting a stored procedure from Sybase to Teradata that contains 20+ while loops and uses global temporary tables. We have found performance to vary dramatically based upon system activity even after allocating to a separate resource partition with a "rush" priority. Are there best practices for converting while loops? Would it be better to convert the looping logic into a bteq script? or individual stored procedure calls?


Thanks for any ideas.

Linda



     
  <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