Supercharge your SQL with indexes

Most developers add indexes by guessing. I showed a systematic approach instead — drawn from building open-source database tools at Prisma — covering which index types exist (B-tree, hash, GIN, GiST), when each one actually helps, and which common mistakes silently kill query performance.

The examples were concrete: queries that went from full table scans to index-only lookups, and the pitfalls that surface only at scale.