Re: Speed up Simple "update" query

[Stanley Wong]

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