The
FOR UPDATE clause is an optional part of a
Simple-column-Name refers to the names visible for the table specified in the FROM clause of the underlying query.
The optimizer is able to use an index even if the column in the index is being updated.
For information about how indexes affect performance, see