Choosing the locking scheme for a table

In general, choice of lock scheme for a new table should be determined by the likelihood that applications will experience lock contention on the table. The decision about whether to change the locking scheme for an existing table can be based on contention measurements on the table, but also needs to take application performance into account.

Here are some typical situations and general guidelines for choosing the locking scheme: