Why indexes are critical for performance in MongoDB - See It in Action

Why Indexes Are Critical for Performance in MongoDB

📖 Scenario: You are managing a MongoDB database for an online bookstore. The database has a collection called books that stores information about each book, including its title, author, and year of publication.Users often search for books by author and year. Without indexes, these searches can be slow because MongoDB must look through every document in the collection.

🎯 Goal: In this project, you will create a books collection, insert sample data, add an index on the author field, and then query the collection to see how indexes improve search performance.

📋 What You'll Learn

Create a books collection with sample documents

Insert at least 5 book documents with title, author, and year

Create an index on the author field

Write a query to find books by a specific author

💡 Why This Matters

🌍 Real World

Indexes are used in real databases to make searches fast, especially when collections have many documents.

💼 Career

Database administrators and backend developers use indexes to optimize application performance and reduce server load.

1

Create the books collection and insert sample data

Create a collection called books and insert these exact documents: { title: 'The Hobbit', author: 'J.R.R. Tolkien', year: 1937 }, { title: '1984', author: 'George Orwell', year: 1949 }, { title: 'To Kill a Mockingbird', author: 'Harper Lee', year: 1960 }, { title: 'The Great Gatsby', author: 'F. Scott Fitzgerald', year: 1925 }, { title: 'Moby Dick', author: 'Herman Melville', year: 1851 }

MongoDB

// Insert the 5 book documents into the books collection
// Your code here

Need a hint?

Use db.books.insertMany([...]) with the exact documents listed.

2

Create an index on the author field

Create an index on the author field of the books collection using db.books.createIndex.

MongoDB

db.books.insertMany([
  { title: 'The Hobbit', author: 'J.R.R. Tolkien', year: 1937 },
  { title: '1984', author: 'George Orwell', year: 1949 },
  { title: 'To Kill a Mockingbird', author: 'Harper Lee', year: 1960 },
  { title: 'The Great Gatsby', author: 'F. Scott Fitzgerald', year: 1925 },
  { title: 'Moby Dick', author: 'Herman Melville', year: 1851 }
])
// Create an index on the author field below
// Your code here

Need a hint?

Use db.books.createIndex({ author: 1 }) to create an ascending index on the author field.

3

Query books by a specific author

Write a query to find all books where the author is exactly 'George Orwell' using db.books.find.

MongoDB

db.books.insertMany([
  { title: 'The Hobbit', author: 'J.R.R. Tolkien', year: 1937 },
  { title: '1984', author: 'George Orwell', year: 1949 },
  { title: 'To Kill a Mockingbird', author: 'Harper Lee', year: 1960 },
  { title: 'The Great Gatsby', author: 'F. Scott Fitzgerald', year: 1925 },
  { title: 'Moby Dick', author: 'Herman Melville', year: 1851 }
])
db.books.createIndex({ author: 1 })
// Query for books by George Orwell below
// Your code here

Need a hint?

Use db.books.find({ author: 'George Orwell' }) to find books by that author.

4

Explain why indexes improve query performance

Add a comment explaining why creating an index on the author field improves query performance in MongoDB.

MongoDB

db.books.insertMany([
  { title: 'The Hobbit', author: 'J.R.R. Tolkien', year: 1937 },
  { title: '1984', author: 'George Orwell', year: 1949 },
  { title: 'To Kill a Mockingbird', author: 'Harper Lee', year: 1960 },
  { title: 'The Great Gatsby', author: 'F. Scott Fitzgerald', year: 1925 },
  { title: 'Moby Dick', author: 'Herman Melville', year: 1851 }
])
db.books.createIndex({ author: 1 })
db.books.find({ author: 'George Orwell' })
// Add a comment explaining why indexes improve query speed
// Your code here

Need a hint?

Write a comment starting with // that explains indexes help MongoDB find data faster by avoiding full collection scans.