- The DBA must analyze the application processing requirement for each db object to determine the optimal locking granularity.
Index entries can also be locked, depending on the DBMS and version in use.
•Index locking can be a significant impediment to performance. Because index entries are usually quite small, it is not uncommon for locking to block application access.