Home Page for the TeradataForum

Archives of the TeradataForum

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

  <Prev Next>  
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>  
Next> Last>>  
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 28 Jun 2020