Single Field Indexes In MongoDB

Single-field indexes in MongoDB improve query performance by indexing one specific field, allowing faster lookups and sorting on that field.

• Indexes store field values in an ordered structure for quick retrieval.
• A single-field index is created on one field of a document.
• Speeds up queries and sorting based on that field.
• Reduces the need for full collection scans.

Index Properties

MongoDB allows specifying additional options when creating indexes to customize their behavior. Some common options include:

• Unique Index: Ensures that indexed field values are unique across the collection.
• Sparse Index: Indexes only documents that contain the indexed field, ignoring documents that do not have the field.
• Partial Index: Indexes documents based on a specified filter expression.

Examples of Single Field Indexes

Here we will consider a collection called books which contains information in various documents are shown below.

(
  {
    "title": "MongoDB Basics",
    "author": "John Doe",
    "publishedYear": 2021
  },
  {
    "title": "Advanced MongoDB Techniques",
    "author": "Jane Smith",
    "publishedYear": 2020
  },
  {
    "title": "Mastering MongoDB",
    "author": "Alice Johnson",
    "publishedYear": 2019
  }
)

Example 1: Create an Index on a Single Field

To create a single field index in MongoDB, you can use the createIndex() method.

db.books.createIndex({ title: 1 })

Output:

title_1

This output confirms that the index was successfully created and added to the collection.

Example 2: Create a Descending Index on a Single Field

Create an index to sort and retrieve books by their publication year in descending order.

db.books.createIndex({ publishedYear: -1 })

Output:

publishedYear_-1

Example 3: Create an Index on an Embedded Field

Modify the documents to include embedded fields.

[
  {
    "title": "MongoDB Basics",
    "author": { "firstName": "John", "lastName": "Doe" },
    "publishedYear": 2021
  },
  {
    "title": "Advanced MongoDB Techniques",
    "author": { "firstName": "Jane", "lastName": "Smith" },
    "publishedYear": 2020
  },
  {
    "title": "Mastering MongoDB",
    "author": { "firstName": "Alice", "lastName": "Johnson" },
    "publishedYear": 2019
  }
]

Query:

Create an index to quickly search for books by the author's first name in the books collection.

db.books.createIndex({ "author.firstName": 1 })

Output:

author.firstName_1

Example 4: Create an Index on an Embedded Document

Create an index to efficiently search for books based on the entire author object in the books collection.

db.books.createIndex({ author: 1 })

Output:

author_1

Benefits of Single Field Indexes

Single-field indexes offer several benefits, as defined below:

• Improved Query Performance: Speeds up queries by allowing fast lookups on the indexed field.
• Reduced Disk I/O: Lowers disk reads by avoiding full collection scans in the database.
• Optimized Sorting: Improves sorting speed when results are ordered by the indexed field.
• Efficient Data Access: Enables MongoDB to quickly locate and fetch matching documents.

Considerations for Single-Field Indexes

While single field indexes provide significant performance benefits, it's essential to consider the following factors:

• Index Maintenance Overhead: Indexes use extra storage and slow down writes due to update overhead.
• Index Selectivity: Index fields with high uniqueness low-selectivity fields give little benefit.
• Query Patterns: Create indexes on fields frequently used in filters, sorting or aggregation.