Archives of the TeradataForum
Message Posted: Tue, 15 Jun 2004 @ 16:57:49 GMT
I agree that ML is at its best in the cases you have described and it would not even occur to me to use ML to delete _all_ rows from a table but while we are at this topic it might be useful to understand what will happen if, say, a code generator submits such a DELETE statement to ML. I see three possibilities which I don't have time to try out right now so I will just write what I think will happen:
1. DELETE is specified before the BEGIN MLOAD command (non-"fast path" mode).
ML will accept the statement. Although it would normally use the Transient Journal in such cases, the DELETE would be fast because TD understands that all the rows will have to be deleted.
2. DELETE is specified in BEGIN IMPORT MLOAD.
The statement will fail because TD expects to see the full PI specification in the statement etc.
3. DELETE is specified in BEGIN DELETE MLOAD. It will be accepted and it will be fast.
As I said, this is just what I think will happen. It would be good to have this confirmed.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 15 Jun 2023|