Archives of the TeradataForum
Message Posted: Thu, 07 Jul 2005 @ 21:08:02 GMT
| Subj: || || Fast Path Insert not possible with Begin Transaction???? |
| From: || || Mirjam Berger |
there was a recent thread here about rollbacks in which Dieter wrote:
| ||An insert/select into an empty table works without transient journal (there's only one entry, "table was empty"), *if* the optimizer knows
that the transaction is commited:|| |
| ||Teradata session: there was no "begin transaction", so the ins/sel is a single transaction.|| |
| ||ANSI session: ins/sel followed by a commit submitted as a multistatement|| |
| ||A rollback will then be processed similar to a delete without where condition, almost immediatly (similar to a truncate in other
Do I read this right?
Will a statement like the following not use fastpath insert?
insert into my_empty_table
select from bla;
I am surprised! Where can I find more information on this????
Thanks for your help!