SQL concurrency and indexing examples

inventory-reservation.sql demonstrates an atomic conditional write. The affected-row count determines whether stock was reserved. This avoids the read-check-write race, but the surrounding order/payment workflow still needs an explicit transaction and failure design.

Test query plans on the same database engine and realistic distribution used in production. An example index is not universally optimal.