Archives of the TeradataForum

Message Posted: Thu, 23 Feb 2012 @ 09:39:42 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

Hello Filipe,

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.

Regards

David George
Dept of Human Services
Australia

	<Prev	Next>		<<First	<Prev	Next>	Last>>