Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Mon, 05 Sep 2011 @ 11:08:59 GMT


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


Subj:   Need performance help with update
 
From:   Ashish

Hi,

We are facing some issues where trying to update one table from another table (too much time).

We have two tables.

1. Table1 has 10M rows which has start ip and end ip along with some other details.

2. Table2 has 5M rows having a particular ip address.


We need to update Table2 from table1 for the particular ip.

The basic update statement will look like this.

     update table2 from
     table1
     set val1=table2.val
     where table2.ip between table1.startip and table1.endip

I needed some help in tuning this query as it is going into high CPU. Please let me know if you need any further information.


Thanks

Ashish



     
  <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: 27 Dec 2016