Sixteen Locks Ought to Be Enough for Anybody

General Developer Forum In The News
,
1

Every query locks every index on a table, even ones it doesn’t use.

Read in full here: