Index intersection behavior in MongoDB - Mini Project: Build & Apply

Understanding Index Intersection Behavior in MongoDB

📖 Scenario: You are managing a small online bookstore database using MongoDB. You want to understand how MongoDB uses multiple indexes together to speed up queries when searching for books by different fields.

🎯 Goal: Build a MongoDB collection with book data, create multiple indexes, and write a query that uses index intersection to find books matching multiple conditions.

📋 What You'll Learn

Create a books collection with documents containing title, author, and year fields.

Create separate indexes on author and year fields.

Write a query to find books by a specific author published in a specific year.

Ensure the query uses index intersection by MongoDB.

💡 Why This Matters

🌍 Real World

Index intersection helps databases efficiently find data when queries filter on multiple fields, improving app speed.

💼 Career

Understanding index intersection is important for database administrators and backend developers to optimize query performance.

1

Create the books collection with sample data

Insert three documents into the books collection with these exact fields and values: { title: "The Great Gatsby", author: "F. Scott Fitzgerald", year: 1925 }, { title: "1984", author: "George Orwell", year: 1949 }, and { title: "Animal Farm", author: "George Orwell", year: 1945 }.

MongoDB

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

Need a hint?

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

2

Create indexes on author and year

Create an index on the author field and another index on the year field in the books collection using db.books.createIndex().

MongoDB

db.books.insertMany([
  { title: "The Great Gatsby", author: "F. Scott Fitzgerald", year: 1925 },
  { title: "1984", author: "George Orwell", year: 1949 },
  { title: "Animal Farm", author: "George Orwell", year: 1945 }
])
// Create index on author
// Create index on year
// Your code here

Need a hint?

Use db.books.createIndex({ author: 1 }) and db.books.createIndex({ year: 1 }) to create ascending indexes.

3

Write a query to find books by George Orwell published in 1945

Write a query using db.books.find() to find documents where author is "George Orwell" and year is 1945.

MongoDB

db.books.insertMany([
  { title: "The Great Gatsby", author: "F. Scott Fitzgerald", year: 1925 },
  { title: "1984", author: "George Orwell", year: 1949 },
  { title: "Animal Farm", author: "George Orwell", year: 1945 }
])
db.books.createIndex({ author: 1 })
db.books.createIndex({ year: 1 })
// Write the query to find George Orwell books from 1945
// Your code here

Need a hint?

Use db.books.find({ author: "George Orwell", year: 1945 }) to filter by both fields.

4

Explain how MongoDB uses index intersection for this query

Add a comment explaining that MongoDB can use index intersection to combine the author and year indexes to efficiently find matching documents.

MongoDB

db.books.insertMany([
  { title: "The Great Gatsby", author: "F. Scott Fitzgerald", year: 1925 },
  { title: "1984", author: "George Orwell", year: 1949 },
  { title: "Animal Farm", author: "George Orwell", year: 1945 }
])
db.books.createIndex({ author: 1 })
db.books.createIndex({ year: 1 })
db.books.find({ author: "George Orwell", year: 1945 })
// Add a comment explaining index intersection usage
// Your code here

Need a hint?

Write a comment starting with // MongoDB can use index intersection describing how indexes combine.