Oracle
Transactions, Isolation, And MVCC
·17 mins
Database
Database
Transactions
Isolation
Mvcc
Locking
Oracle
A practical backend view of ACID, anomalies, MVCC, locks, and retry behavior
Composite Index And Query Triage
·13 mins
Database
Database
Composite-Index
Query-Plan
Oracle
Sargability
Query-Optimization
Reason about composite indexes through predicates, ordering, projection, plan shape, and write cost