Archives of the TeradataForum
Message Posted: Mon, 24 Sep 2001 @ 18:05:45 GMT
| 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
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?
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'
LexisNexis I/S DBA