Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Mon, 16 Jul 2012 @ 15:19:56 GMT


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


Subj:   Re: Insert into table with same select is too slow
 
From:   Diehl, Robert

It is probably a NUPI dup (non unique primary index problem). This occurs because of duplicate row checking.

Make sure the primary index choice is unique or nearly unique.

You can also make the table multiset to avoid duplicate row checking. However, you know have to worry about duplicate rows. Also the table will be skewed so performance will suffer.


Thanks,

Robert Diehl
Travelocity Data Warehouse DBA



     
  <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