Why should Select ForUpdate be avoided when no update is performed?

Question

Accepted Answer

BPCheckSelectForUpdateAbsent warns when select forUpdate is used but no update happens.This:


Locks records unnecessarily


Reduces concurrency


Fix:


Use normal select, or


Enable Optimistic Concurrency Control (OCC) on the table.

Why should Select ForUpdate be avoided when no update is performed?

Answer with Explanation