{"id":2233,"date":"2020-12-07T08:54:55","date_gmt":"2020-12-07T16:54:55","guid":{"rendered":"https:\/\/devblogs.microsoft.com\/cosmosdb\/?p=2233"},"modified":"2020-12-07T08:54:55","modified_gmt":"2020-12-07T16:54:55","slug":"managing-indexing-azure-portal","status":"publish","type":"post","link":"https:\/\/devblogs.microsoft.com\/cosmosdb\/managing-indexing-azure-portal\/","title":{"rendered":"Managing indexing through the Azure Portal in Azure Cosmos DB\u2019s API for MongoDB"},"content":{"rendered":"

Adding new indexes just got even easier! You can now manage indexing in Azure Cosmos DB\u2019s API for MongoDB accounts directly in the Azure Portal. In this blog, we\u2019ll cover how to add and remove indexes using the new indexing policy editor. We\u2019ll also highlight the differences in best practices for indexing in Azure Cosmos DB\u2019s API for MongoDB and MongoDB.<\/p>\n

Navigating to the new indexing policy editor<\/strong><\/p>\n

The new indexing policy editor is located within the Scale & Settings <\/strong>section of the Data Explorer <\/strong>in all Azure Cosmos DB\u2019s API for MongoDB version 3.6 accounts. If you are using version 3.2, here\u2019s our guide for upgrading<\/a>.<\/p>\n

\"Navigate<\/a><\/p>\n

Adding indexes<\/strong><\/p>\n

The below example shows how to add three single field indexes (name, age, and address) and one wildcard index (children.$**). In this example, we add four indexes in one single indexing policy change. You must click the Save<\/strong> button in order to apply your changes.\u00a0In this example, it is faster to create the four new indexes if we add them together, as opposed to four separate indexing policy changes.<\/p>\n

\"Add<\/a><\/p>\n

Tracking index progress<\/strong><\/p>\n

When an index transformation is in-progress, you should wait for the change to complete before making additional changes. You\u2019ll see this banner while an indexing transformation is still in-progress:<\/p>\n

\"Index<\/a><\/p>\n

Dropping indexes<\/strong><\/p>\n

The below example shows how to drop two indexes (address and children.$**). In this example, we drop both indexes in one single indexing policy change. Like when adding indexes, changes are only applied after we click the Save<\/strong> button.<\/p>\n

\"Drop<\/a><\/strong><\/p>\n

Understanding the biggest differences between indexing in Azure Cosmos DB\u2019s API for MongoDB and MongoDB<\/strong><\/p>\n

While the best indexing best practices in Azure Cosmos DB\u2019s API for MongoDB and MongoDB are similar, there are some key differences:<\/p>\n\n\n\n\n\n\n
Concept<\/strong><\/td>\nAzure Cosmos DB\u2019s API for MongoDB<\/strong><\/td>\nMongoDB<\/strong><\/td>\n<\/tr>\n
Wildcard indexes<\/td>\nSupport multiple fields per query predicate. Query predicates can use a mix of wildcard and non-wildcard indexes.<\/p>\n

 <\/p>\n

Best practice:<\/strong> Wildcard index performance is equivalent to creating multiple single field indexes. If you are unsure about which indexes to create, try adding a wildcard index for all fields.<\/td>\n

Support, at most, one field in any given query predicate.<\/p>\n

 <\/td>\n<\/tr>\n

Compound indexes<\/td>\nOnly used for sorting query results.<\/p>\n

 <\/p>\n

Best practice: <\/strong>If a query predicate filters on multiple fields, create multiple single field indexes. Query predicates can use multiple single field indexes.<\/td>\n

Used in most query predicates with multiple fields.<\/td>\n<\/tr>\n
Modifying indexing policy<\/td>\nIn Azure Cosmos DB, one single index structure holds references to all indexed fields. Therefore, making many indexing changes together is more efficient than making multiple separate and smaller indexing changes.<\/p>\n

 <\/p>\n

Best practice:<\/strong> If you need to add multiple new indexes, the indexes will be created more quickly if you add all the indexes together. You should prefer the createIndexes() command over createIndex() since it gives you the ability to add multiple indexes at once.<\/p>\n

 <\/td>\n

In MongoDB, each index is logically independent.<\/p>\n

 <\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

 <\/p>\n

Learn more about indexing in Azure Cosmos DB\u2019s API for MongoDB<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"

In this blog, we\u2019ll cover how to add and remove indexes using the new indexing policy editor. We\u2019ll also highlight the differences in best practices for indexing in Azure Cosmos DB\u2019s API for MongoDB and native MongoDB.<\/p>\n","protected":false},"author":12128,"featured_media":61,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"image","meta":{"_acf_changed":false,"footnotes":""},"categories":[15,14,818],"tags":[],"class_list":["post-2233","post","type-post","status-publish","format-image","has-post-thumbnail","hentry","category-mongodb-api","category-core-sql-api","category-query","post_format-post-format-image"],"acf":[],"blog_post_summary":"

In this blog, we\u2019ll cover how to add and remove indexes using the new indexing policy editor. We\u2019ll also highlight the differences in best practices for indexing in Azure Cosmos DB\u2019s API for MongoDB and native MongoDB.<\/p>\n","_links":{"self":[{"href":"https:\/\/devblogs.microsoft.com\/cosmosdb\/wp-json\/wp\/v2\/posts\/2233","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/devblogs.microsoft.com\/cosmosdb\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/devblogs.microsoft.com\/cosmosdb\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/cosmosdb\/wp-json\/wp\/v2\/users\/12128"}],"replies":[{"embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/cosmosdb\/wp-json\/wp\/v2\/comments?post=2233"}],"version-history":[{"count":0,"href":"https:\/\/devblogs.microsoft.com\/cosmosdb\/wp-json\/wp\/v2\/posts\/2233\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/cosmosdb\/wp-json\/wp\/v2\/media\/61"}],"wp:attachment":[{"href":"https:\/\/devblogs.microsoft.com\/cosmosdb\/wp-json\/wp\/v2\/media?parent=2233"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/cosmosdb\/wp-json\/wp\/v2\/categories?post=2233"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/cosmosdb\/wp-json\/wp\/v2\/tags?post=2233"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}