Indexes

Indexes and Performance

Learn how clustered and nonclustered indexes speed up SQL Server queries, and how to read execution plans and statistics to diagnose slow queries.

B-Tree Indexes Explained

Learn how PostgreSQL's default B-tree index works internally and why it is the right choice for equality and range queries.

GIN and GiST Indexes

Understand when to reach for GIN and GiST index types to accelerate full-text search, JSONB containment, arrays, and geometric or range data.

Index Maintenance and Bloat

Understand why indexes accumulate dead space over time, how to detect bloat, and the tools PostgreSQL provides to reclaim it safely.

Partial and Expression Indexes

Use partial indexes to index only a relevant subset of rows and expression indexes to index computed values, keeping indexes smaller and more targeted.

Compound Indexes

Understand how MongoDB compound indexes combine multiple fields, the ESR rule for ordering keys, and how they support sorting and covered queries.

Indexes in MongoDB

Learn how MongoDB indexes work internally, why they speed up queries, and how to create and manage the core index types.

Text and Geospatial Indexes

Learn how MongoDB's text indexes power keyword search and how 2dsphere geospatial indexes enable location-based queries.

Indexes and How They Work

How database indexes use B-tree structures to speed up lookups, and why they add overhead to writes.