Archives of the TeradataForum
Message Posted: Thu, 23 Feb 2012 @ 09:39:42 GMT
I have been having the same problems. ?A number of approaches - 1. change all left outer joins to update statements, 2. remove statistics on key tables and see if this fools the optimiser into thinking there is only one row in the table. ?This may then get it to duplicate the smaller table across all AMPs. ?Have you have a new node added? ?We have and this problem seems to have occurred since then.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 23 Jun 2019|