Re: Speed up Simple "update" query
I think MySQL 8.0 handles such subqueries better. It also has better tools for sussing out a bottleneck, eg Explain Analyze.
This is no faster?
update shipment a
join packages b on a.id=b.shipment_id and b.tracking_no ='AC125279615BG'
set a.updated=current_timestamp ;
Subject
Views
Written By
Posted
587
April 13, 2022 01:45AM
287
April 13, 2022 08:53AM
Re: Speed up Simple "update" query
273
April 13, 2022 09:24AM
306
April 14, 2022 01:45AM
309
April 14, 2022 08:07AM
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.