WL#2444: Optimisation of UPDATE for handlers supporting update of indexed fields
Affects: Server-7.1 — Status: In-Progress — Priority: Medium
UPDATE queries where the UPDATE is applied on the indexed field always read all records before starting to apply the updates. Some handlers can handle updates also of indexed fields. They should thus use the normal UPDATE loop instead. It should be enough to introduce a new table flag to handle this optimisation and use it in one place in the sql_update.cc file.
New table flag HA_CAN_SCAN_UPDATED_INDEX if this is set then used_key_is_modified is not used to execute filesort before applying the updates.
Copyright (c) 2000, 2017, Oracle Corporation and/or its affiliates. All rights reserved.