Sobes.tech
Middle

What are predicate locks in the context of the Serializable isolation level? How does the DBMS track conditions in SELECT ... WHERE ... queries to prevent the write skew anomaly without locking the entire table?