Configure a custom indexing policy by using the Azure portal

To configure a custom indexing policy in Azure Cosmos DB, follow these steps:

Step 1: Create a Cosmos DB account

If you don’t have a Cosmos DB account already, you can create one using the Azure portal. Go to the Azure portal, search for “Azure Cosmos DB,” and create a new account.

Step 2: Open Azure Cosmos DB account

Once your Cosmos DB account is created, navigate to the account in the Azure portal and open it.

Step 3: Navigate to the “Indexes” tab

From the left-hand navigation pane, click on the “Indexes” tab under the “Data Explorer” section.

Step 4: Create a new custom indexing policy

On the “Indexes” tab, click on the “Add” button to create a new custom indexing policy.

Step 5: Configure the custom indexing policy

In the “Add Indexing Policy” blade, you can configure the following settings:

• Indexing Mode: Choose between “Consistent,” which provides index consistency for large-scale data ingestion, and “Lazy,” which provides eventual consistency for better query performance.
• Automatic Indexing: Enable or disable automatic indexing. If disabled, you can define custom indexes manually.
• Included Paths: Specify the properties that should be indexed using wildcard or explicit paths. For example, “/” will include all properties, and “/*” will include all first-level properties.
• Excluded Paths: Specify the properties that should be excluded from indexing using wildcard or explicit paths. For example, “/” will exclude all properties, and “/*” will exclude all first-level properties.
• Composite Indexes (optional): Define composite indexes by selecting multiple paths.

Step 6: Save the custom indexing policy

After configuring the custom indexing policy, click on the “Save” button to apply the changes.

That’s it! You have successfully configured a custom indexing policy in Azure Cosmos DB using the Azure portal. The new indexing policy will be applied to all the collections within your Cosmos DB account.

By customizing the indexing policy, you can optimize query performance, reduce the storage footprint, and control the cost of indexing in Azure Cosmos DB. It allows you to fine-tune your database to meet specific application requirements and deliver optimal performance.

In conclusion, this article covered the process of configuring a custom indexing policy using the Azure portal for Azure Cosmos DB. Custom indexing policies are essential for optimizing query performance and improving the overall efficiency of your Cosmos DB database. By leveraging the flexibility of custom indexing, you can fine-tune your database to meet the specific needs of your application.