Archives of the TeradataForum
Message Posted: Wed, 22 Oct 2003 @ 15:37:20 GMT
I believe the Table1 is redistributing on all amps and then performing the JOIN operations . Use derived tables to duplicate the small table on all amps . Hope this might fix your problem .
It will be great if you can post the explains
|Copyright 2016 - All Rights Reserved|
|Last Modified: 15 Jun 2023|