Archives of the TeradataForum

Message Posted: Wed, 14 Sep 2005 @ 13:06:28 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

Rachana Agarwal wrote:

It's the same as:

     delete from  ;

or

     delete  ;

Just syntax...

No, both are fast, if it's known to the optimizer, that the transaction is commited after that delete, e.g. BTEQ:

- Implicit transaction in Teradata mode session (auto-commit):

     Delete from ;

- Multistatement including ET in an explicit transaction in Teradata

     mode session:
     bt;
     ...
     Delete from 
     ; et;

- multistatement in ANSI mode session:

     Delete from 
     ;commit;

Dieter

	<Prev	Next>		<<First	<Prev	Next>	Last>>