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


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.



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