Database indexing patterns, index types, composite and covering indexes, partial and expression indexes, EXPLAIN workflows, and performance tuning strategies across PostgreSQL, MySQL, SQLite, and MongoDB.
Category
Database Indexing Cheat Sheets
Database indexing patterns, index types, EXPLAIN workflows, and tuning strategies across SQL and NoSQL databases.
Popular in Database Indexing
Quick picks to get you started.
Indexing Anti-Patterns and Maintenance
Avoid over-indexing, duplicate indexes, low-value indexes, stale statistics, and maintenance mistakes.
Updated 3/28/2026
EXPLAIN, ANALYZE, and Verify Index Usage
Use EXPLAIN tools across PostgreSQL, MySQL, SQLite, and MongoDB to prove whether an index actually helps.
Updated 3/28/2026
Partial, Expression, and Functional Indexes
High-leverage index patterns for subsets of data and computed predicates across PostgreSQL, MySQL, and SQLite.
Updated 3/28/2026
MongoDB Index Types and Query Patterns
Single-field, compound, multikey, text, wildcard, partial, TTL, and unique index patterns for MongoDB.
Updated 3/28/2026
SQLite Indexes and Query Planner
SQLite CREATE INDEX patterns, expression and partial indexes, EXPLAIN QUERY PLAN, and lightweight performance tuning.
Updated 3/28/2026
MySQL Index Strategies and Verification
Composite indexes, invisible indexes, descending indexes, generated-column indexing, and EXPLAIN workflows in MySQL.
Updated 3/28/2026
All Database Indexing sheets
9 published sheets · sorted by recently updated.
Indexing Anti-Patterns and Maintenance
Avoid over-indexing, duplicate indexes, low-value indexes, stale statistics, and maintenance mistakes.
Updated 3/28/2026
EXPLAIN, ANALYZE, and Verify Index Usage
Use EXPLAIN tools across PostgreSQL, MySQL, SQLite, and MongoDB to prove whether an index actually helps.
Updated 3/28/2026
Partial, Expression, and Functional Indexes
High-leverage index patterns for subsets of data and computed predicates across PostgreSQL, MySQL, and SQLite.
Updated 3/28/2026
MongoDB Index Types and Query Patterns
Single-field, compound, multikey, text, wildcard, partial, TTL, and unique index patterns for MongoDB.
Updated 3/28/2026
SQLite Indexes and Query Planner
SQLite CREATE INDEX patterns, expression and partial indexes, EXPLAIN QUERY PLAN, and lightweight performance tuning.
Updated 3/28/2026
MySQL Index Strategies and Verification
Composite indexes, invisible indexes, descending indexes, generated-column indexing, and EXPLAIN workflows in MySQL.
Updated 3/28/2026
PostgreSQL Index Types and Strategies
Use PostgreSQL B-tree, GIN, GiST, BRIN, partial indexes, expression indexes, and concurrent builds effectively.
Updated 3/28/2026
SQL B-tree, Composite, and Covering Indexes
Practical SQL indexing patterns for equality, range filters, ordering, include columns, and covering scans.
Updated 3/28/2026
Database Indexing Basics and Access Patterns
Core indexing concepts, selectivity, left-prefix behavior, and practical heuristics for when to add an index.
Updated 3/28/2026