Archives of the TeradataForum
Message Posted: Fri, 27 Aug 1999 @ 15:29:53 GMT
| Subj: | | Re: How to stop or avoid Rollback or recovery process |
| |
| From: | | John Grass |
This makes sense when you think about it. If you are updating an existing table (via update, insert or delete) and kill the update,
Teradata is going to guarantee that the table will be recovered to its original state -- even across restarts.
One technique you can try is to design the queries to only insert rows into empty tables. In this case, Teradata will not log or go
through a rollback, as Teradata knows that the original state of the target table is "empty."
If you have multiple steps that need to insert rows into the same table, you can either put all these steps into one multistatement
request, or you can run multiple steps -- each inserting rows into their own empty table, consolidating the results at the finish.
If you have a need to update rows in the target table then you are going to have to live with the rollbacks. There is no way that I know
of to "turn off" logging in this case.
John
| 
