How the system makes its decision if it has a choice

If the lock granularity (whether to lock rows or entire tables) is not forced by the user, the system makes a decision using the following rules:
Related concepts
Lock escalation threshold