jtrombley24
New Member
- Joined
- Feb 21, 2016
- Messages
- 27
I have two identical tables, one is linked to an oracle database and the other is a local table, created out of the linked table. I have an update query, that updates the local table from the linked table. The following query takes about five minutes to run. There are only ~6000 rows so I shouldn't take too long. What am I missing?
Thanks in advance!
Code:
UPDATE
MIDEX_V_PROCESS_ORDER_DETAIL_QTY AS m INNER JOIN MIDEX_V_PROCESS_ORDER_DETAILS AS d ON m.PROCESS_ORDER = d.PROCESS_ORDER
SET
d.BATCH_NUMBER = m.[BATCH_NUMBER],
d.COMPONENT_BATCH = m.[COMPONENT_BATCH],
d.COMPONENT_MATERIAL_NUMBER = m.[COMPONENT_MATERIAL_NUMBER],
d.SCHED_START_DATE = m.[SCHED_START_DATE],
d.ACTUAL_FINISH_DATE = m.[ACTUAL_FINISH_DATE],
d.ORDER_QTY = m.[ORDER_QTY],
d.ACTUAL_QTY = m.[ACTUAL_QTY]
WHERE
d.PROCESS_ORDER = m.PROCESS_ORDER;
Thanks in advance!