MySQL Forums
Forum List  »  Performance

Re: Speed up Simple "update" query
Posted by: Peter Brawley
Date: April 13, 2022 09:24AM

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 and b.tracking_no ='AC125279615BG'
set a.updated=current_timestamp ;

Options: ReplyQuote

Written By
April 13, 2022 01:45AM
Re: Speed up Simple "update" query
April 13, 2022 09:24AM

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.