Re: slow update-join query
Read again. Explain results depend on DDL including indexing, and data. You've not posted Explain results for ...
update table1 a, table2 t set a.current_version = 1 where a.source_article_id = t.source_article_id and a.version = t.max_version;
Edited 1 time(s). Last edit at 06/08/2022 12:27PM by Peter Brawley.
Subject
Views
Written By
Posted
231
June 07, 2022 12:55PM
108
June 07, 2022 02:27PM
102
June 07, 2022 02:55PM
108
June 07, 2022 05:06PM
Re: slow update-join query
96
June 08, 2022 09:51AM
Sorry, only registered users may post in this forum.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.