Our INSERTs use REPEATABLEREAD hint. What effect does this have?

169 views Asked by At

When profiling our Microsoft Dynamics NAV application with SQL Server Profiler, I get INSERTs with the REPEATABLEREAD hint.

What effect does the REPEATABLEREAD hint has on an INSERT statement?

In SQL Server 2012 - How does "Repeatable Read" isolation level work? the REPEATABLEREAD hint is described, but this seems to apply to SELECTs only.

Extra info:

  • Not all INSERTs have the REPEATABLEREAD hint, so maybe Microsoft Dynamics NAV application issues the hint under specific circumstances.
  • The INSERTs are simple INSERT statement (no SELECT INTO or JOINs). The execution plan also shows a simple INSERT
0

There are 0 answers