Index Design & Selection - Learn how to design optimal index strategies

Query Optimization Fundamentals - Understand how indexes fit into query optimization

Understanding EXPLAIN Plans - Analyze how indexes are used in execution plans

Index Maintenance & Monitoring - Keep indexes healthy and performant

Create a B-tree, Hash, and GIN index on the same table and compare performance with EXPLAIN ANALYZE

Build a full-text search system using GIN indexes with to_tsvector and to_tsquery

Implement a geospatial restaurant finder using GiST indexes with PostGIS

Design a covering index for a hot query and measure the performance improvement

Create partial indexes for time-based queries (last 30 days) and compare storage savings

Build a multi-column index and test different column orders to understand left-to-right usage

Implement a product search with multiple index types (Hash for SKU, GIN for full-text, B-tree for price)

Audit a table with 6+ indexes, identify unused ones, and consolidate overlapping indexes

Explain B-tree vs Hash indexes. When would you use each? What are the trade-offs?

What is a GIN index? How does it differ from B-tree? Give 3 use cases.

Explain covering indexes. Why are they 3-5x faster? What are the downsides?

What is a partial index? Give a real-world example where it saves 80% storage.

How do you choose column order for multi-column indexes? Explain the left-to-right rule.

A geospatial query takes 3 seconds. What index type would you use and why?

You have 8 indexes on a table and writes are slow. How do you optimize?

Explain GiST indexes. What are they used for? How do they differ from GIN?

When would you NOT create an index? Give 3 scenarios.

Design an index strategy for a product search with: SKU lookup, full-text search, price range, and tags.

PostgreSQL Index Types Documentation - https://www.postgresql.org/docs/current/indexes-types.html

Use The Index, Luke - https://use-the-index-luke.com/

PostGIS Spatial Indexing - https://postgis.net/workshops/postgis-intro/indexing.html

MySQL Index Optimization - https://dev.mysql.com/doc/refman/8.0/en/optimization-indexes.html

SQL Server Index Design Guide - https://docs.microsoft.com/en-us/sql/relational-databases/sql-server-index-design-guide