MySQL Forums
Forum List  »  Performance

Re: slow update-join query
Posted by: Peter Brawley
Date: June 08, 2022 09:51AM

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.

Options: ReplyQuote


Subject
Views
Written By
Posted
460
June 07, 2022 12:55PM
189
June 07, 2022 01:00PM
213
June 07, 2022 01:19PM
223
June 07, 2022 02:27PM
204
June 07, 2022 02:55PM
206
June 07, 2022 03:26PM
207
June 07, 2022 05:06PM
185
June 07, 2022 06:20PM
Re: slow update-join query
217
June 08, 2022 09:51AM


Sorry, you can't reply to this topic. It has been closed.

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.