Home Page for the TeradataForum

Archives of the TeradataForum

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

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

Subj:   Re: Duplicate to all amps
From:   David George

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.


David George
Dept of Human Services

  <Prev Next>   <<First <Prev Next> Last>>  
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 23 Jun 2019