Archives of the TeradataForum

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

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

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>>