Home Page for the TeradataForum
 
https:

Archives of the TeradataForum

Message Posted: Mon, 16 Jul 2012 @ 17:39:37 GMT


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


Subj:   Re: Insert into table with same select is too slow
 
From:   de Wet, Johannes M

Jay - Check the PI on your target table.

It is probably not 'unique enough' ( i.e. a lot of repeating values per PI, or is highly skewed). The following might options to consider:

(1) Consider changing the PI to be more unique, or

(2)changing the target table to MULTISET, instead of SET (will remove the duplicate check step), or

(3) consider changing the table to a no-PI table, if there isn't any good PI candidate column(s).


Johannes de Wet
Unum



     
  <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: 28 Jun 2020