MySQL Forums
Forum List  »  Performance

Re: Speed up Simple "update" query
Posted by: Stanley Wong
Date: April 14, 2022 01:45AM

Thanks,

The inner join Query return within a second and the query plan changed.

So, I should avoid using the "IN with subquery" which cause the Index scan ?


"id" "select_type" "table" "partitions" "type" "possible_keys" "key" "key_len" "ref" "rows" "filtered" "Extra"
"1" "SIMPLE" "b" \N "ref" "fk_shpt_units_shipment1_idx,package-tracking_no" "shpt_package-tracking_no" "138" "const" "1" "100.00" "Using index"
"1" "UPDATE" "a" \N "eq_ref" "PRIMARY" "PRIMARY" " 8" " b.shipment_id" "1" "100.00" \N

Options: ReplyQuote


Subject
Views
Written By
Posted
517
April 13, 2022 01:45AM
Re: Speed up Simple "update" query
261
April 14, 2022 01:45AM


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.