Choosing the locking scheme for a table

In general, choose a lock scheme for a new table based on the likelyhood that applications will experience lock contention on the table. Whether to change the locking scheme for an existing table can be based on contention measurements on the table, but should also take application performance into account.

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