|
Archives of the TeradataForumMessage Posted: Wed, 14 Sep 2005 @ 13:06:28 GMT
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 - multistatement in ANSI mode session: Delete from Dieter
| ||||||||||||||||||||||||||||||||||||||||||||||||||||||
| ||||||||||||||||||||||||||||||||||||||||||||||||||||||
Copyright 2016 - All Rights Reserved | ||||||||||||||||||||||||||||||||||||||||||||||||||||||
Last Modified: 15 Jun 2023 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||