Text indexes for search in MongoDB - Step-by-Step Execution

Concept Flow - Text indexes for search

Create text index on fields

↓

Insert documents into collection

↓

Run text search query

↓

MongoDB uses text index

↓

Return matching documents

↓

Display search results

Create a text index on fields, then run a text search query that uses the index to find matching documents.

Execution Sample

MongoDB

db.books.createIndex({title: "text", description: "text"})
db.books.insertMany([
  {title: "MongoDB Basics", description: "Learn MongoDB quickly"},
  {title: "Advanced MongoDB", description: "Deep dive into MongoDB"}
])
db.books.find({$text: {$search: "MongoDB"}})

Create a text index on title and description, insert two books, then search for 'MongoDB' in those fields.

Execution Table

Step	Action	Input/Query	MongoDB Process	Output/Result
1	Create text index	{title: "text", description: "text"}	Builds text index on title and description fields	Index created
2	Insert documents	[{title: "MongoDB Basics", description: "Learn MongoDB quickly"}, {title: "Advanced MongoDB", description: "Deep dive into MongoDB"}]	Documents stored, indexed by text index	2 documents inserted
3	Run text search	{$text: {$search: "MongoDB"}}	Searches text index for 'MongoDB'	Returns both documents
4	Display results	N/A	Documents matched by text search	[{title: "MongoDB Basics", description: "Learn MongoDB quickly"}, {title: "Advanced MongoDB", description: "Deep dive into MongoDB"}]
5	Run text search	{$text: {$search: "Basics"}}	Searches text index for 'Basics'	Returns first document only
6	Display results	N/A	Documents matched by text search	[{title: "MongoDB Basics", description: "Learn MongoDB quickly"}]
7	Run text search	{$text: {$search: "Python"}}	Searches text index for 'Python'	No documents match
8	Display results	N/A	No documents found	[]

💡 No more queries; text search returns matching documents or empty if none found

Variable Tracker

Variable	Start	After Step 2	After Step 3	After Step 5	After Step 7	Final
textIndex	none	created on title and description	used for search	used for search	used for search	used for search
documents	empty	[2 inserted]	[2 found for 'MongoDB']	[1 found for 'Basics']	[] for 'Python'	[]
searchQuery	none	none	"MongoDB"	"Basics"	"Python"	none

Key Moments - 3 Insights

Why does the search for 'Basics' return only one document?

Because only the first document's title contains the word 'Basics', as shown in execution_table row 5 and 6.

What happens if you search for a word not in any document?

The search returns an empty array, no documents match, as shown in execution_table rows 7 and 8.

Why do we need to create a text index before searching?

MongoDB uses the text index to quickly find matches; without it, text search queries won't work efficiently or at all, as shown in execution_table row 1.

Visual Quiz - 3 Questions

Look at the execution_table, what is the output after running the search query {$text: {$search: "MongoDB"}}?

A Only the first document is returned

B Both documents are returned

C No documents are returned

D An error occurs

💡 Hint

Check execution_table row 3 and 4 for the search with 'MongoDB'

At which step does MongoDB create the text index?

A Step 1

B Step 3

C Step 2

D Step 4

💡 Hint

Look at execution_table row 1 where the index is created

If you search for 'Python', what will the output be according to the execution_table?

A Both documents returned

B Only second document returned

C No documents returned

D Only first document returned

💡 Hint

See execution_table rows 7 and 8 for the search with 'Python'

Concept Snapshot

Text indexes allow fast search on string fields.
Create with createIndex({field: "text"}).
Use $text with $search to find matching documents.
Search matches words in indexed fields.
No index means no text search.
Results include documents containing search words.

Full Transcript

This visual execution shows how MongoDB text indexes work for search. First, a text index is created on the title and description fields of the books collection. Then two documents are inserted. When a text search query is run with {$text: {$search: "MongoDB"}}, MongoDB uses the text index to find both documents because both contain the word 'MongoDB'. Searching for 'Basics' returns only the first document because only it contains that word. Searching for 'Python' returns no documents because none contain that word. The text index is essential for efficient text search. Without it, the queries would not return results. This step-by-step trace helps beginners see how text indexes enable fast searching of text fields in MongoDB.

Practice

1. What is the main purpose of creating a text index in MongoDB?

easy

A. To encrypt text data for security

B. To enable fast searching of text within string fields

C. To store large text files inside the database

D. To sort documents by text fields alphabetically

Solution

1. Step 1: Understand what a text index does

   A text index allows MongoDB to quickly search text inside string fields of documents.

2. Step 2: Compare options with the purpose

   Sorting, storing files, or encrypting are not functions of text indexes.

3. Final Answer:

   To enable fast searching of text within string fields -> Option B

4. Quick Check:

   Text index = fast text search [OK]

Hint: Text index = fast search inside text fields [OK]

Common Mistakes:

• Confusing text index with sorting index
• Thinking text index stores files
• Assuming text index encrypts data

2. Which of the following is the correct syntax to create a text index on the description field in a MongoDB collection named products?

easy

A. db.products.createTextIndex({ description: 1 })

B. db.products.createIndex({ description: 'string' })

C. db.products.createIndex({ description: 'text' })

D. db.products.createIndex({ description: 1 })

Solution

1. Step 1: Recall the syntax for creating a text index

   The correct method is createIndex with the field set to 'text' type.

2. Step 2: Check each option

   db.products.createIndex({ description: 'text' }) uses createIndex with { description: 'text' }, which is correct. Others use wrong methods or types.

3. Final Answer:

   db.products.createIndex({ description: 'text' }) -> Option C

4. Quick Check:

   Use createIndex with 'text' type [OK]

Hint: Use createIndex({field: 'text'}) to make text index [OK]

Common Mistakes:

• Using 'string' instead of 'text' for index type
• Using createTextIndex (not a valid method)
• Creating normal ascending index (1) instead of text

3. Given a collection articles with a text index on fields title and content, what will the following query return?

db.articles.find({ $text: { $search: "mongodb tutorial" } })

medium

A. Documents containing both words 'mongodb' and 'tutorial' in title or content

B. Documents containing exactly the phrase 'mongodb tutorial' only

C. Documents containing either 'mongodb' or 'tutorial' in any field

D. Documents sorted alphabetically by title

Solution

1. Step 1: Understand $text and $search behavior

   The $search operator looks for documents containing all search words (AND behavior) in indexed text fields.

2. Step 2: Analyze the query

   The query searches for documents with both 'mongodb' and 'tutorial' in either title or content fields.

3. Final Answer:

   Documents containing both words 'mongodb' and 'tutorial' in title or content -> Option A

4. Quick Check:

   $search finds all words, not exact phrase [OK]

Hint: $search finds all words, not exact phrase [OK]

Common Mistakes:

• Thinking $search matches exact phrase only
• Assuming $search matches any single word (OR)
• Expecting sorting by title automatically

4. You tried to create two text indexes on a collection: one on title and another on description. What is the problem with this approach?

medium

A. MongoDB allows only one text index per collection

B. Text indexes must be created on numeric fields only

C. You must create text indexes using createTextIndex method

D. Text indexes cannot be created on multiple fields

Solution

1. Step 1: Recall MongoDB text index limitation

   MongoDB allows only one text index per collection, but it can cover multiple fields.

2. Step 2: Evaluate the options

   MongoDB allows only one text index per collection correctly states the limitation. Others are incorrect about field types or methods.

3. Final Answer:

   MongoDB allows only one text index per collection -> Option A

4. Quick Check:

   One text index per collection rule [OK]

Hint: Only one text index allowed per collection [OK]

Common Mistakes:

• Trying to create multiple text indexes on same collection
• Using wrong method name for creating text index
• Thinking text indexes only work on numbers

5. You want to create a text index on title and summary fields but give title twice the search weight of summary. Which is the correct way to create this weighted text index?

hard

A. db.books.createIndex({ title: 'text', summary: 'text' }, { weights: { summary: 2, title: 1 } })

B. db.books.createIndex({ title: 'text', summary: 'text' }, { weight: { title: 2, summary: 1 } })

C. db.books.createIndex({ title: 'text', summary: 'text' }, { weight: { summary: 2, title: 1 } })

D. db.books.createIndex({ title: 'text', summary: 'text' }, { weights: { title: 2, summary: 1 } })

Solution

1. Step 1: Recall syntax for weighted text indexes

   Weights option is an object named weights specifying field weights.

2. Step 2: Check options for correct spelling and values

   db.books.createIndex({ title: 'text', summary: 'text' }, { weights: { title: 2, summary: 1 } }) uses weights correctly and assigns title weight 2, summary 1 as required.

3. Final Answer:

   db.books.createIndex({ title: 'text', summary: 'text' }, { weights: { title: 2, summary: 1 } }) -> Option D

4. Quick Check:

   Use 'weights' option with correct field weights [OK]

Hint: Use 'weights' option with field weights object [OK]

Common Mistakes:

• Using 'weight' instead of 'weights' option
• Swapping weights between fields
• Not specifying weights object correctly