Designing Data-Intensive Applications: The Big Ideas Behind Reliable, Scalable, and Maintainable Systems

by Martin Kleppmann

If there is no suitable index where a range lock can be attached, the database can fall back to a shared lock on the entire table.