Locking and performanceRow-level locking improves concurrency in a multi-user system.
However, a large number of row locks can degrade performance.Lockingperformance implications of
discussed the way the optimizer makes
some compile-time decisions about escalating row locks to table locks for
performance reasons. This section discusses ways in which the
system and the user can
make similar lock escalations.