Sparse indexes in MongoDB - Mini Project: Build & Apply

Creating and Using Sparse Indexes in MongoDB

📖 Scenario: You are managing a MongoDB collection that stores user profiles. Not all users provide their phone numbers, so the phone field is missing in some documents. To optimize queries that search by phone number without indexing documents missing this field, you want to create a sparse index.

🎯 Goal: Build a MongoDB sparse index on the phone field to efficiently query users who have provided their phone numbers.

📋 What You'll Learn

Create a MongoDB collection named users with specific user documents.

Add a sparse index on the phone field.

Write a query to find users with a specific phone number using the sparse index.

Ensure the sparse index excludes documents without the phone field.

💡 Why This Matters

🌍 Real World

Sparse indexes help optimize database queries when some documents do not have certain fields, common in user profiles or optional data scenarios.

💼 Career

Understanding sparse indexes is important for database administrators and backend developers to improve query performance and storage efficiency.

1

DATA SETUP: Create the users collection with sample documents

Insert these exact documents into a MongoDB collection called users: { name: "Alice", age: 28, phone: "123-456-7890" }, { name: "Bob", age: 34 }, { name: "Charlie", age: 25, phone: "987-654-3210" }, and { name: "Diana", age: 30 }.

MongoDB

// Insert the specified documents into the users collection
// Your code here

Need a hint?

Use db.users.insertMany() with an array of documents.

2

CONFIGURATION: Define the sparse index on the phone field

Create a sparse index on the phone field in the users collection using db.users.createIndex() with the option { sparse: true }.

MongoDB

db.users.insertMany([
  { name: "Alice", age: 28, phone: "123-456-7890" },
  { name: "Bob", age: 34 },
  { name: "Charlie", age: 25, phone: "987-654-3210" },
  { name: "Diana", age: 30 }
])
// Create a sparse index on the phone field
// Your code here

Need a hint?

Use db.users.createIndex({ phone: 1 }, { sparse: true }) to create the sparse index.

3

CORE LOGIC: Query users with a specific phone number

Write a query using db.users.find() to find the user document where the phone field equals "123-456-7890".

MongoDB

db.users.insertMany([
  { name: "Alice", age: 28, phone: "123-456-7890" },
  { name: "Bob", age: 34 },
  { name: "Charlie", age: 25, phone: "987-654-3210" },
  { name: "Diana", age: 30 }
])
db.users.createIndex({ phone: 1 }, { sparse: true })
// Find the user with phone number "123-456-7890"
// Your code here

Need a hint?

Use db.users.find({ phone: "123-456-7890" }) to query the user.

4

COMPLETION: Verify the sparse index excludes documents without phone

Add a command to list all indexes on the users collection using db.users.getIndexes() to confirm the sparse index exists.

MongoDB

db.users.insertMany([
  { name: "Alice", age: 28, phone: "123-456-7890" },
  { name: "Bob", age: 34 },
  { name: "Charlie", age: 25, phone: "987-654-3210" },
  { name: "Diana", age: 30 }
])
db.users.createIndex({ phone: 1 }, { sparse: true })
db.users.find({ phone: "123-456-7890" })
// List all indexes on the users collection
// Your code here

Need a hint?

Use db.users.getIndexes() to see all indexes on the collection.