Re: Speed up Simple "update" query
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
Subject
Views
Written By
Posted
124
April 13, 2022 01:45AM
48
April 13, 2022 08:53AM
58
April 13, 2022 09:24AM
Re: Speed up Simple "update" query
55
April 14, 2022 01:45AM
55
April 14, 2022 08:07AM
Sorry, only registered users may post in this forum.
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.