Articles → MONGODB → Combined Text Index In Mongodb

Combined Text Index In Mongodb

In this article, we will discuss the combined text index in MongoDB.

Purpose

A combined text index in MongoDB is an index that spans multiple fields in a document and is optimized for full-text search queries across those fields simultaneously. This type of index allows you to perform efficient text searches that involve multiple fields without having to create separate text indexes on each field.

Syntax

db.collection.createIndex(
  {
    field1: "text",
    field2: "text",
    // Add additional fields here if needed
  }
)

Example

Consider the following collection: -

Picture showing the sample document collection

In the above collection, we will create a combined index on the name and country fields. We will use the following query: -

db.Employee.createIndex(
  {
    name: "text",
    country: "text"
  }
)

Output

Posted By -	Karan Gupta

Posted On -	Friday, May 10, 2024

Query/Feedback

Your Email Id		**

Subject		*

Query/Feedback	Characters remaining 250	**