Multikey indexes for arrays in MongoDB

Introduction

Multikey indexes help you quickly find documents when you have arrays inside them. They make searching inside arrays fast and easy.

You have a list of tags for blog posts and want to find posts by tag quickly.

You store multiple phone numbers for each contact and want to search by any number.

You keep an array of product categories and want to find all products in a category.

You want to speed up queries that check if an array contains a specific value.

Syntax

MongoDB

db.collection.createIndex({ 'arrayField': 1 })

This creates a multikey index if 'arrayField' is an array in your documents.

The index works on each element inside the array separately.

Examples

Creates a multikey index on the 'tags' array field in the 'books' collection.

MongoDB

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

Indexes the 'phoneNumbers' array so you can quickly find contacts by any phone number.

MongoDB

db.contacts.createIndex({ phoneNumbers: 1 })

Indexes the 'categories' array to speed up category searches.

MongoDB

db.products.createIndex({ categories: 1 })

Sample Program

This example creates a collection 'books' with a 'tags' array. It adds a multikey index on 'tags' to speed up searches. Then it finds all books tagged 'fiction' and prints their titles.

MongoDB

use myLibrary

// Insert sample documents with arrays
db.books.insertMany([
  { title: 'Book A', tags: ['fiction', 'adventure'] },
  { title: 'Book B', tags: ['non-fiction', 'history'] },
  { title: 'Book C', tags: ['fiction', 'mystery'] }
])

// Create a multikey index on the tags array
db.books.createIndex({ tags: 1 })

// Query to find books with tag 'fiction'
const fictionBooks = db.books.find({ tags: 'fiction' }).toArray()

// Print the titles of books found
fictionBooks.forEach(book => print(book.title))

Important Notes

Multikey indexes automatically handle arrays without extra setup.

They can slow down writes because the index updates for each array element.

Use multikey indexes when you often search for values inside arrays.

Summary

Multikey indexes speed up queries on array fields by indexing each element.

They are easy to create by indexing the array field normally.

Great for searching tags, categories, or any list inside documents.

Practice

1. What is the main purpose of a multikey index in MongoDB when applied to an array field?

easy

A. To index each element inside the array separately for faster queries

B. To store the entire array as a single indexed value

C. To prevent duplicate values inside the array

D. To convert arrays into strings before indexing

Solution

1. Step 1: Understand what a multikey index does

   A multikey index indexes each element of an array field separately, allowing efficient queries on any element inside the array.

2. Step 2: Compare options with this behavior

   Only To index each element inside the array separately for faster queries describes indexing each element separately. Other options describe incorrect behaviors.

3. Final Answer:

   To index each element inside the array separately for faster queries -> Option A

4. Quick Check:

   Multikey index = indexes array elements separately [OK]

Hint: Multikey indexes each array element, not the whole array [OK]

Common Mistakes:

• Thinking multikey indexes the whole array as one value
• Confusing multikey with unique constraints
• Assuming arrays are converted to strings before indexing

2. Which of the following is the correct syntax to create a multikey index on the tags array field in a MongoDB collection named posts?

easy

A. db.posts.createIndex({ tags: [1] })

B. db.posts.createIndex({ tags: 1 })

C. db.posts.createIndex({ tags: 'multikey' })

D. db.posts.createIndex({ tags: { $each: 1 } })

Solution

1. Step 1: Recall MongoDB index creation syntax

   To create an index on a field, use createIndex({ field: 1 }) for ascending order.

2. Step 2: Understand multikey index creation

   MongoDB automatically creates a multikey index if the field is an array. No special keyword is needed.

3. Final Answer:

   db.posts.createIndex({ tags: 1 }) -> Option B

4. Quick Check:

   Index array field normally = multikey index [OK]

Hint: Just index the array field normally; MongoDB handles multikey [OK]

Common Mistakes:

• Using special keywords like 'multikey' in index definition
• Trying to pass array syntax in index keys
• Misusing MongoDB operators inside createIndex

3. Given the collection products with documents like { _id: 1, categories: ["electronics", "gadgets"] }, what will be the result of the query db.products.find({ categories: "gadgets" }) if a multikey index exists on categories?

medium

A. [{ _id: 1, categories: ["electronics"] }]

B. [] (empty array)

C. Error: Cannot query array field

D. [{ _id: 1, categories: ["electronics", "gadgets"] }]

Solution

1. Step 1: Understand query on array field with multikey index

   The query searches for documents where the array contains "gadgets". The multikey index allows fast lookup of such elements.

2. Step 2: Check the document matching the query

   The document with _id 1 has "gadgets" in its categories array, so it matches and will be returned.

3. Final Answer:

   [{ _id: 1, categories: ["electronics", "gadgets"] }] -> Option D

4. Quick Check:

   Query array element with multikey index returns matching docs [OK]

Hint: Query matches docs with array containing the value [OK]

Common Mistakes:

• Expecting empty result because array is indexed
• Thinking query errors on array fields
• Confusing partial array matches with exact matches

4. You created a multikey index on the tags array field, but your query db.articles.find({ tags: "news" }) is slow. What is a likely reason?

medium

A. The index was created on a different field, not tags

B. Multikey indexes do not support queries on array elements

C. You must use $elemMatch to query array fields

D. MongoDB does not index array fields automatically

Solution

1. Step 1: Check index field correctness

   If the index is on a different field, queries on tags won't use the index, causing slowness.

2. Step 2: Verify multikey index behavior

   Multikey indexes do support queries on array elements without special operators like $elemMatch.

3. Final Answer:

   The index was created on a different field, not tags -> Option A

4. Quick Check:

   Index on correct field = fast query [OK]

Hint: Ensure index is on the queried array field [OK]

Common Mistakes:

• Believing multikey indexes don't support element queries
• Thinking $elemMatch is always required
• Assuming MongoDB indexes arrays automatically without createIndex

5. You have a collection users with documents containing an array field roles. You want to create a multikey index on roles but only for users who are active (active: true). Which is the correct way to create a partial multikey index for this?

hard

A. db.users.createIndex({ roles: 1 }, { condition: { active: true } })

B. db.users.createIndex({ roles: 1, active: true })

C. db.users.createIndex({ roles: 1 }, { partialFilterExpression: { active: true } })

D. db.users.createIndex({ roles: 1 }, { filter: { active: true } })

Solution

1. Step 1: Understand partial indexes in MongoDB

   Partial indexes use partialFilterExpression to index only documents matching a filter.

2. Step 2: Apply partialFilterExpression with multikey index

   Creating an index on roles with partialFilterExpression: { active: true } indexes only active users' roles.

3. Final Answer:

   db.users.createIndex({ roles: 1 }, { partialFilterExpression: { active: true } }) -> Option C

4. Quick Check:

   Use partialFilterExpression for conditional multikey index [OK]

Hint: Use partialFilterExpression option for conditional indexes [OK]

Common Mistakes:

• Using invalid options like filter or condition
• Trying to include filter in index key object
• Not knowing partialFilterExpression syntax