Re: Speed up Simple "update" query

[Peter Brawley]

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 ;