Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Thu, 13 Mar 2008 @ 16:53:16 GMT

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

Subj:   Re: Stored Procedure Error Handling
From:   Michael Larkins


You wrote:

  It seems to me that Teradata needs another version of a Temporary table that facilitates very fast consecutive Inserts, perhaps based upon zero logging or something.  

This seems to imply that you missed Dieter's point: CURSOR processing is slowing it down to a serial operation, not the SQL nor the temporary table.

As a matter of fact, the ANSI implementation of temporary tables on Teradata also allows you to turn off the journalling (NO LOG) which makes it extremely fast, but there is no recovery from an abort situation. Regardless, anytime you do an operation like delete all rows or insert into an empty table, Teradata does not journal every row - therefore called Fast Path Processing.


Michael Larkins
Certified Teradata Master
Certified Teradata SQL Instructor

  <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: 28 Jun 2020