Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Mon, 24 Sep 2001 @ 18:05:45 GMT


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


Subj:   Updating one table with values from another
 
From:   Karen Gebhard

We are trying to update one table with values from another. Each table has around 1600 rows but the update query (below) is taking a long time - at 30 minutes we killed it. This is in development so killing it didn't mess things up. I have collected stats on both tables.

The from table has a unique key of terr_id. Why would this run so long or is there a better way to do this?

UPDATE   eti.sales_org_hier
FROM     offline_staging_incr_dev.sale_offline_conv
SET         BUS_UNIT_NAME = offline_staging_incr_dev.sale_offline_conv.BUS_UNIT_NAME
WHERE    eti.sales_org_hier.terr_id = offline_staging_incr_dev.sale_offline_conv.terr_id
AND        eti.sales_org_hier.online_offline_cd = 'OFF'
AND       offline_staging_incr_dev.sale_offline_conv.on_off = 'Offline'
;

Karen Gebhard
LexisNexis I/S 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: 27 Dec 2016