Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Thu, 18 Dec 2003 @ 14:34:48 GMT


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


Subj:   Re: Tearadata SP and ASP
 
From:   Doug Little

Deiter

Given your statement

  "Regarding cursors, every DBMS has performance problems with cursors, because cursors are processed serially, whereas a DBMS is optimized for set operations. On Teradata it's especially bad, because a SP runs on one node only using a single CPU."  



If teradata sp's are executed concurrently from different sessions, or within the same session, will they execute concurrently or serially?

Typically sp's are small row level processes that are being executed by triggers and/or clients. So the parallelism comes from having multiple calling clients, not from within the dbms.

Thoughts?


Thanks

Doug Little



     
  <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