3 ms·
In SQLServer in general it's better to write one time SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED, than write hint NOLOCK agains each table. Result is the
by Ingaz 16y ago
In SQLServer in general it's better to write one time SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED, than write hint NOLOCK agains each table.
Result is the same.
This is not a hint for planner. You can write it for PostgreSQL also (I mean SET TRANSACTION).