 |
 |
Archives of the TeradataForum
Message Posted: Thu, 13 Mar 2008 @ 16:53:16 GMT
| Subj: | | Re: Stored Procedure Error Handling |
| |
| From: | | Michael Larkins |
David:
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.
Regards,
Michael Larkins
Certified Teradata Master
Certified Teradata SQL Instructor
| |
