Archives of the TeradataForum
Message Posted: Thu, 13 Mar 2008 @ 16:53:16 GMT
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.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|