When profiling our Microsoft Dynamics NAV application with SQL Server Profiler, I get INSERT
s 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