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

Single Choice
Views 7

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.

Related Articles:

This section is dedicated exclusively to Questions & Answers. For an in-depth exploration of MB-700: Microsoft Dynamics 365: Finance and Operations Apps Solution Architect, click the links and dive deeper into this subject.

Go to Question List

Join Our telegram group to ask Questions

Click below button to join our groups.

Ask Question - CSE
Programming Language - PDF