Archives of the TeradataForum
Message Posted: Mon, 26 Apr 2004 @ 19:05:55 GMT
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 ?
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|