A PostgreSQL index lab on an airline dataset: B-tree, hash, LIKE, composite and covering indexes
Step-by-step EXPLAIN ANALYZE on 2 million bookings: with and without an index, B-tree vs hash, LIKE with collations and pg_trgm, when the planner skips an index, composite column order, ORDER BY, and covering indexes with INCLUDE.