语句如下:
一个关联查询后更新的语句,其中要更新的这个pacs.SELECTION_TBL数据很少,我单独去运行里边的查询语句,速度是特别快,但是只要运行这个update部分,速度会很慢,实在不知道怎么回事了。谢谢。
UPDATE
PACS.SELECTION_TBL
SET
UPDATETIME = CURRENT TIMESTAMP
WHERE
SERIES_LID IN ( SELECT DISTINCT IM.SERIES_LID
FROM
PACS.SERIES_TBL SE ,
PACS.IMAGE_TBL1 IM
WHERE
IM.SOURCE_IMAGE_SEQ_SOP_UID IN (SELECT
DISTINCT REF.REF_SOP_UID
FROM
PACS.SR_REF_SOP_SQ_TBL REF ,
PACS.SR_CURRENT_REQ_EVIDENCE_SQ_TBL CURRENT ,
PACS.SR_DOC_GENERAL_TBL DOC ,
PACS.SERIES_TBL SE
WHERE
SERIES_UID = '1.2.840.113619.2.278.3.1846205990.338.1674894259.257'
AND
SE.SERIES_LID = DOC. SERIES_LID AND
DOC. SR_DOC_GENERAL_LID = CURRENT.SR_DOC_GENERAL_LID
AND
CURRENT. SR_CURRENT_REQ_EVIDENCE_SQ_LID
= REF. SR_CURRENT_REQ_EVIDENCE_SQ_LID
))
收起