![](//teradataforum.com/imgs/ptdfw1.gif) |
![](//teradataforum.com/imgs/ptdfw2.gif) |
Archives of the TeradataForum
Message Posted: Wed, 22 Jun 2011 @ 14:15:11 GMT
Subj: | | Work table during Multi load update and delete |
|
From: | | Gutta_Ram |
HI,
I understand that during ML insert, data is sent in 64k blocks to all amps and then hasing happens and each data row is sent to the actual amp
where it is going to reside forever. And in this process, worktable will be used to store data sent by other amps and execution plan of each
sql.
Can anyone explain in more elaborative way,how work table will be made use of especially in case of ML update and delete.
Thanks in Advance!!!
| |