 |
 |
Archives of the TeradataForum
Message Posted: Wed, 14 Sep 2005 @ 18:41:32 GMT
| Subj: | | Re: Difference between Delete and delete All |
| |
| From: | | Dieter Noeth |
Xinyu Zhang wrote:
| | There are so many explanation about this problem. | |
| | I am so confuse about it. | |
| | According to my original opinion, they are different. | |
| | There is not transaction journal of "Delete all" operation. | |
| | So it's fast than "delete" operation. | |
| | Who can give a final answer? | |
SQL Reference: Data Manipulation Statements
Chapter 3: SQL Data Manipulation Language Statement Syntax
DELETE
Unconstrained (Fast Path) DELETE Processing
Dieter
| |
