 |
 |
Archives of the TeradataForum
Message Posted: Mon, 26 Apr 2004 @ 19:05:55 GMT
| Subj: | | Redistribution of SPOOL |
| |
| From: | | Rick Davis |
Can anyone explain me this below explain step
"We do an All-AMPs JOIN step from Spool 5490 (Last Use) by way of an all-rows scan, which is joined to Spool 5491. Spool 5490 and
Spool 5491 are joined using a merge join . The result goes into Spool 5492, which is redistributed by hash code to all AMPs."
How can I calculate the size of intermediate spool 54592 ? , on what PI this spool file will try to distribute the data across the AMPs,
how can I eliminate this redistribution ?
TIA,
Rick
| |
