 |
 |
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 |
Hi,
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
DBMSes). | |
Do I read this right?
Will a statement like the following not use fastpath insert?
Begin transaction;
insert into my_empty_table
select from bla;
end transaction;
I am surprised! Where can I find more information on this????
Thanks for your help!
Mirjam
| |
