liveBook · Manning

Composite index

A composite index is a database index whose key contains multiple fields or columns, ordered according to the index definition.

How 4 Manning books explain it

Just Use Postgres!

A composite index is a database index defined over multiple columns, ordering entries first by one column and then by subsequent columns.

How it is used
Optimizes queries that filter or order by related columns, such as regional leaderboards and device-specific time-series ranges.
How deep it goes
Explains column ordering, leading-column behavior, execution plans, and caveats, but defers broader index administration.
Examples
Demonstrates regional player rankings, filtered score queries, and smartwatch measurements filtered by timestamp and device.
What you can do after
Diagnose/debug with it by creating indexes, reading EXPLAIN plans, and checking whether ordering and filters use the intended index.

Read how Just Use Postgres! explains composite index →

Crack Any Codebase with AI

A composite index is a database index built over multiple columns to support searches or ordering involving those columns.

How it is used
Uses composite indexes to infer the application's hottest query patterns while reviewing a schema table by table.
How deep it goes
Explains their diagnostic meaning and product connection, but does not descend into database indexing internals or execution plans.
Examples
Uses Booking indexes combining startTime, endTime, status, userId, eventTypeId, and createdAt.
What you can do after
Evaluate schema decisions by mapping each composite index to the recurring product query or surface it supports.

Read how Crack Any Codebase with AI explains composite index →

MongoDB 8.0 in Action, Third Edition

A compound index is an index whose key consists of multiple document fields.

How it is used
Speeds recurring MongoDB queries that filter on multiple fields or sort on multiple fields.
How deep it goes
Defines index prefixes, works through creation commands and execution plans, and specifies sort-key order without detailing index storage internals.
Examples
Uses movie indexes on release year, type, IMDb rating, and title, plus theater and runtime sorting queries.
What you can do after
Build it from scratch with createIndex, align field order with queries and sorts, and check index use with explain("executionStats").

Read how MongoDB 8.0 in Action, Third Edition explains composite index →

Natural Language Processing in Action, Second Edition

A composite index combines multiple indexing algorithms or stages into a single retrieval structure.

How it is used
Uses staged vector retrieval to reduce memory pressure while supporting large-scale nearest-neighbor search.
How deep it goes
Defines multi-stage indexing and explains memory and configuration tradeoffs, but stops short of implementation procedures or tuning recipes.
Examples
Uses IVFPQ, HNSW plus PQ, NumPy quantization, Faiss, Weaviate, and a New York Times ANN comparison.
What you can do after
Evaluate composite-index tradeoffs and recognize when memory savings justify added configuration complexity.

Read how Natural Language Processing in Action, Second Edition explains composite index →

Also covered in

What to know first

Related concepts

Questions about composite index

What is composite index?

A composite index is a database index whose key contains multiple fields or columns, ordered according to the index definition.

Which Manning books explain composite index?

Just Use Postgres!, Crack Any Codebase with AI, MongoDB 8.0 in Action, Third Edition and Natural Language Processing in Action, Second Edition.

What should I know before learning composite index?

Manning books that teach composite index usually introduce indexing first.

What is the difference between composite index and single-column index?

A composite index is a database index whose key contains multiple fields or columns, ordered according to the index definition. A single-column index is a database index whose key is derived from one field or column and whose entries are organized by its values.

What is composite index a kind of?

Composite index is a kind of indexing. Indexing is the process of assigning or using positions, keys, or lookup structures to identify and access elements or records.

These guides are generated from the text of Manning books by Manning's knowledge graph and link to the sections they draw on. The full books are available on liveBook and at manning.com.