Single-column index
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.
Just Use Postgres!
A single-column index is a database index whose key is derived from one table column.
- How it is used
- Optimizes searches, filters, ordering, and selected time-series or queue operations involving one table column.
- How deep it goes
- Explains creation, B-tree and hash behavior, execution plans, and planner trade-offs, while deferring broader composite-index design.
- Examples
- Uses game scores and champion titles, time-series timestamps, and message-queue creation times as concrete indexing cases.
- What you can do after
- Apply PostgreSQL CREATE INDEX and EXPLAIN to create indexes and verify whether queries use them effectively.
MongoDB 8.0 in Action, Third Edition
A single-field index is an index whose key consists of one document field and whose entries are ordered by that field's values.
- How it is used
- Speeds frequent queries on one MongoDB document field and can support filtering and sorting on that field.
- How deep it goes
- Walks through index creation and execution-plan checks, but does not detail the index’s internal storage structure.
- Examples
- Uses a movies.runtime index with getIndexes() and explain("executionStats"), plus a date-based transactions TTL index.
- What you can do after
- Apply it via mongosh createIndex() and diagnose its use with getIndexes() and explain("executionStats").
Read how MongoDB 8.0 in Action, Third Edition explains single-column index →
What to know first
- indexingIndexing is the process of assigning or using positions, keys, or lookup structures to identify and access elements or records.
Related concepts
- composite indexcontrasts with · A composite index is a database index whose key contains multiple fields or columns, ordered according to the index definition.
- indexingkind of · Indexing is the process of assigning or using positions, keys, or lookup structures to identify and access elements or records.
- TTL indexincludes · A TTL index is a MongoDB index that automatically expires and removes documents according to an indexed date field and expiration interval.
- B-treeuses · A B-tree is a balanced multiway search tree that maintains ordered keys and supports efficient searching, insertion, deletion, and sequential access.
- PostgreSQLproduced by · PostgreSQL is an open-source object-relational database management system that stores and queries data using SQL and supports extensible data types and operations.
- primary keyincludes · A primary key is a field or combination of fields whose values uniquely identify each row or item in a data store.
Questions about single-column index
What is single-column index?
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.
Which Manning books explain single-column index?
Just Use Postgres! and MongoDB 8.0 in Action, Third Edition.
What should I know before learning single-column index?
Manning books that teach single-column index usually introduce indexing first.
What is the difference between single-column index and composite index?
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. A composite index is a database index whose key contains multiple fields or columns, ordered according to the index definition.
What kinds of single-column index are there?
Kinds of single-column index include TTL index and primary key.
What is single-column index a kind of?
Single-column 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.

