Row-level locking improves concurrency in a multi-user system. However, a large number of row locks can degrade performance. 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.