Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Mon, 24 Apr 2006 @ 09:40:22 GMT


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


Subj:   Stored Procedures Vs Select Insert
 
From:   Anomy Anom

<-- Anonymously Posted: Monday, April 24, 2006 00:10 -->

Hello Gurus,

Im a new addition to the teradata developer team and from Oracle Background. I find it very intriguing sometimes to see people using tens of temporary tables to transform data by way of select-inserts rather than use a stored procedure to accomplish the same. Is there any reason behind this? Do the cursor based row by row processing in SPs fail to leverage teradata parallellism effectively? Or can there be any other reason behind this?


Regards



     
  <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