Databases
Intermediate
Pro
Database Indexing
How indexes work and when to use them
16 min read
1 view
Learn how B-tree and hash indexes work internally, how the query planner uses them, when to create composite and covering indexes, and how to diagnose slow queries using EXPLAIN ANALYZE.