{"id":11230,"date":"2025-11-18T08:00:53","date_gmt":"2025-11-18T16:00:53","guid":{"rendered":"https:\/\/devblogs.microsoft.com\/cosmosdb\/?p=11230"},"modified":"2025-11-25T09:11:04","modified_gmt":"2025-11-25T17:11:04","slug":"introducing-index-advisor-for-azure-documentdb-preview","status":"publish","type":"post","link":"https:\/\/devblogs.microsoft.com\/cosmosdb\/introducing-index-advisor-for-azure-documentdb-preview\/","title":{"rendered":"Introducing Index Advisor for Azure DocumentDB (Preview)"},"content":{"rendered":"<p><span data-contrast=\"auto\">We\u2019re excited to announce the <\/span>public preview of <b><span data-contrast=\"auto\">Index Advisor for Azure DocumentDB (with MongoDB Compatibility). <\/span><\/b><span data-contrast=\"auto\">It is <\/span><span data-contrast=\"auto\">a built-in AI powered performance tuning assistant that helps you understand slow queries, diagnose inefficiencies, and automatically generate optimized index recommendations.<\/span><span data-ccp-props=\"{&quot;134233117&quot;:false,&quot;134233118&quot;:false,&quot;335559738&quot;:240,&quot;335559739&quot;:240}\">\u00a0<\/span><\/p>\n<p><span data-contrast=\"auto\">With <\/span><a href=\"https:\/\/learn.microsoft.com\/azure\/documentdb\/index-advisor\"><span data-contrast=\"none\">Index Advisor<\/span><\/a><span data-contrast=\"auto\">, you can quickly analyze query structure, execution plans, and collection statistics to receive <\/span><span data-contrast=\"auto\">data-driven, plain-English index recommendations.<\/span><span data-contrast=\"auto\"> Even better, you can apply these recommendations directly inside the <\/span><a href=\"https:\/\/marketplace.visualstudio.com\/items?itemName=ms-azuretools.vscode-documentdb\"><span data-contrast=\"none\">DocumentDB for VS Code<\/span><\/a><span data-contrast=\"auto\"> extension, making performance tuning faster, easier, and seamlessly integrated into your development workflow.<\/span><span data-ccp-props=\"{&quot;134233117&quot;:false,&quot;134233118&quot;:false,&quot;335559738&quot;:240,&quot;335559739&quot;:240}\">\u00a0<\/span><\/p>\n<h3 aria-level=\"2\"><b><span data-contrast=\"none\">Why Index Advisor?<\/span><\/b><span data-ccp-props=\"{&quot;134233117&quot;:false,&quot;134233118&quot;:false,&quot;134245418&quot;:true,&quot;134245529&quot;:true,&quot;335559738&quot;:299,&quot;335559739&quot;:299}\">\u00a0<\/span><\/h3>\n<p><span data-contrast=\"auto\">Indexes are one of the most important tools for optimizing database performance, but identifying the right ones can be challenging. Index Advisor simplifies this by:<\/span><span data-ccp-props=\"{&quot;134233117&quot;:false,&quot;134233118&quot;:false,&quot;335559738&quot;:240,&quot;335559739&quot;:240}\">\u00a0<\/span><\/p>\n<ul>\n<li aria-setsize=\"-1\" data-leveltext=\"\uf0b7\" data-font=\"Symbol\" data-listid=\"6\" data-list-defn-props=\"{&quot;335552541&quot;:1,&quot;335559685&quot;:720,&quot;335559991&quot;:360,&quot;469769226&quot;:&quot;Symbol&quot;,&quot;469769242&quot;:[8226],&quot;469777803&quot;:&quot;left&quot;,&quot;469777804&quot;:&quot;\uf0b7&quot;,&quot;469777815&quot;:&quot;hybridMultilevel&quot;}\" data-aria-posinset=\"1\" data-aria-level=\"1\"><span data-contrast=\"auto\">Detecting slow or inefficient queries<\/span><span data-ccp-props=\"{&quot;134233117&quot;:false,&quot;134233118&quot;:false,&quot;335559738&quot;:240,&quot;335559739&quot;:240}\">\u00a0<\/span><\/li>\n<\/ul>\n<ul>\n<li aria-setsize=\"-1\" data-leveltext=\"\uf0b7\" data-font=\"Symbol\" data-listid=\"6\" data-list-defn-props=\"{&quot;335552541&quot;:1,&quot;335559685&quot;:720,&quot;335559991&quot;:360,&quot;469769226&quot;:&quot;Symbol&quot;,&quot;469769242&quot;:[8226],&quot;469777803&quot;:&quot;left&quot;,&quot;469777804&quot;:&quot;\uf0b7&quot;,&quot;469777815&quot;:&quot;hybridMultilevel&quot;}\" data-aria-posinset=\"2\" data-aria-level=\"1\"><span data-contrast=\"auto\">Providing prioritized index recommendations based on performance impact<\/span><span data-ccp-props=\"{&quot;134233117&quot;:false,&quot;134233118&quot;:false,&quot;335559738&quot;:240,&quot;335559739&quot;:240}\">\u00a0<\/span><\/li>\n<\/ul>\n<ul>\n<li aria-setsize=\"-1\" data-leveltext=\"\uf0b7\" data-font=\"Symbol\" data-listid=\"6\" data-list-defn-props=\"{&quot;335552541&quot;:1,&quot;335559685&quot;:720,&quot;335559991&quot;:360,&quot;469769226&quot;:&quot;Symbol&quot;,&quot;469769242&quot;:[8226],&quot;469777803&quot;:&quot;left&quot;,&quot;469777804&quot;:&quot;\uf0b7&quot;,&quot;469777815&quot;:&quot;hybridMultilevel&quot;}\" data-aria-posinset=\"3\" data-aria-level=\"1\"><span data-contrast=\"auto\">Explaining <\/span><i><span data-contrast=\"auto\">why<\/span><\/i><span data-contrast=\"auto\"> each index matters in clear, actionable language<\/span><span data-ccp-props=\"{&quot;134233117&quot;:false,&quot;134233118&quot;:false,&quot;335559738&quot;:240,&quot;335559739&quot;:240}\">\u00a0<\/span><\/li>\n<\/ul>\n<ul>\n<li aria-setsize=\"-1\" data-leveltext=\"\uf0b7\" data-font=\"Symbol\" data-listid=\"6\" data-list-defn-props=\"{&quot;335552541&quot;:1,&quot;335559685&quot;:720,&quot;335559991&quot;:360,&quot;469769226&quot;:&quot;Symbol&quot;,&quot;469769242&quot;:[8226],&quot;469777803&quot;:&quot;left&quot;,&quot;469777804&quot;:&quot;\uf0b7&quot;,&quot;469777815&quot;:&quot;hybridMultilevel&quot;}\" data-aria-posinset=\"4\" data-aria-level=\"1\"><span data-contrast=\"auto\">Letting you apply recommendations in a single click from VS Code<\/span><span data-ccp-props=\"{&quot;134233117&quot;:false,&quot;134233118&quot;:false,&quot;335559738&quot;:240,&quot;335559739&quot;:240}\">\u00a0<\/span><\/li>\n<\/ul>\n<ul>\n<li aria-setsize=\"-1\" data-leveltext=\"\uf0b7\" data-font=\"Symbol\" data-listid=\"6\" data-list-defn-props=\"{&quot;335552541&quot;:1,&quot;335559685&quot;:720,&quot;335559991&quot;:360,&quot;469769226&quot;:&quot;Symbol&quot;,&quot;469769242&quot;:[8226],&quot;469777803&quot;:&quot;left&quot;,&quot;469777804&quot;:&quot;\uf0b7&quot;,&quot;469777815&quot;:&quot;hybridMultilevel&quot;}\" data-aria-posinset=\"5\" data-aria-level=\"1\"><span data-contrast=\"auto\">Automatically re-analyzing your query after index creation so you can compare before-and-after performance<\/span><span data-ccp-props=\"{&quot;134233117&quot;:false,&quot;134233118&quot;:false,&quot;335559738&quot;:240,&quot;335559739&quot;:240}\">\u00a0<\/span><\/li>\n<\/ul>\n<p><span data-contrast=\"auto\">Whether you&#8217;re a developer or DBA, Index Advisor removes the guesswork from index design.<\/span><span data-ccp-props=\"{&quot;134233117&quot;:false,&quot;134233118&quot;:false,&quot;335559738&quot;:240,&quot;335559739&quot;:240}\">\u00a0<\/span><\/p>\n<p><a href=\"https:\/\/devblogs.microsoft.com\/cosmosdb\/wp-content\/uploads\/sites\/52\/2025\/11\/indexAdvisor.png\"><img decoding=\"async\" class=\"size-full wp-image-11234 aligncenter\" src=\"https:\/\/devblogs.microsoft.com\/cosmosdb\/wp-content\/uploads\/sites\/52\/2025\/11\/indexAdvisor.png\" alt=\"indexAdvisor image\" width=\"2031\" height=\"1240\" srcset=\"https:\/\/devblogs.microsoft.com\/cosmosdb\/wp-content\/uploads\/sites\/52\/2025\/11\/indexAdvisor.png 2031w, https:\/\/devblogs.microsoft.com\/cosmosdb\/wp-content\/uploads\/sites\/52\/2025\/11\/indexAdvisor-300x183.png 300w, https:\/\/devblogs.microsoft.com\/cosmosdb\/wp-content\/uploads\/sites\/52\/2025\/11\/indexAdvisor-1024x625.png 1024w, https:\/\/devblogs.microsoft.com\/cosmosdb\/wp-content\/uploads\/sites\/52\/2025\/11\/indexAdvisor-768x469.png 768w, https:\/\/devblogs.microsoft.com\/cosmosdb\/wp-content\/uploads\/sites\/52\/2025\/11\/indexAdvisor-1536x938.png 1536w\" sizes=\"(max-width: 2031px) 100vw, 2031px\" \/><\/a><\/p>\n<h3 aria-level=\"2\"><b><span data-contrast=\"none\">How It Works<\/span><\/b><span data-ccp-props=\"{&quot;134233117&quot;:false,&quot;134233118&quot;:false,&quot;134245418&quot;:true,&quot;134245529&quot;:true,&quot;335559738&quot;:299,&quot;335559739&quot;:299}\">\u00a0<\/span><\/h3>\n<p><iframe src=\"\/\/www.youtube.com\/embed\/OKbadcnAiio\" width=\"560\" height=\"314\" allowfullscreen=\"allowfullscreen\"><\/iframe><\/p>\n<ol>\n<li><span data-contrast=\"auto\">Run the query from the <\/span><b><span data-contrast=\"auto\">Query Insights<\/span><\/b><span data-contrast=\"auto\"> tab in the <\/span><a href=\"https:\/\/marketplace.visualstudio.com\/items?itemName=ms-azuretools.vscode-documentdb\"><span data-contrast=\"none\">DocumentDB for VS Code extension<\/span><\/a><span data-contrast=\"auto\">.<\/span><span data-ccp-props=\"{&quot;134233117&quot;:false,&quot;134233118&quot;:false,&quot;335559738&quot;:240,&quot;335559739&quot;:240}\">\u00a0<\/span><\/li>\n<li><span data-contrast=\"auto\">Index Advisor collects and analyzes the execution plan and statistics.<\/span><span data-ccp-props=\"{&quot;134233117&quot;:false,&quot;134233118&quot;:false,&quot;335559738&quot;:240,&quot;335559739&quot;:240}\">\u00a0<\/span><\/li>\n<li><span data-contrast=\"auto\">Github Copilot evaluates query patterns and recommends optimized index strategies.<\/span><span data-ccp-props=\"{&quot;134233117&quot;:false,&quot;134233118&quot;:false,&quot;335559738&quot;:240,&quot;335559739&quot;:240}\">\u00a0<\/span><\/li>\n<li><span data-contrast=\"auto\">Click <\/span><b><span data-contrast=\"auto\">Apply<\/span><\/b><span data-contrast=\"auto\"> to create the suggested index.<\/span><span data-ccp-props=\"{&quot;134233117&quot;:false,&quot;134233118&quot;:false,&quot;335559738&quot;:240,&quot;335559739&quot;:240}\">\u00a0<\/span><\/li>\n<li><span data-contrast=\"auto\">Once indexing finishes, Index Advisor automatically reruns the query and updates performance metrics so you can validate improvements instantly.<\/span><span data-ccp-props=\"{&quot;134233117&quot;:false,&quot;134233118&quot;:false,&quot;335559738&quot;:240,&quot;335559739&quot;:240}\">\u00a0<\/span><\/li>\n<\/ol>\n<p><span data-contrast=\"auto\">This end-to-end experience helps you spot bottlenecks, apply fixes, and measure results, all without leaving your favorite editor. Learn more about it here: <\/span><a href=\"https:\/\/learn.microsoft.com\/azure\/documentdb\/index-advisor\"><span data-contrast=\"none\">https:\/\/learn.microsoft.com\/azure\/documentdb\/index-advisor<\/span><\/a><span data-ccp-props=\"{&quot;134233117&quot;:false,&quot;134233118&quot;:false,&quot;335559738&quot;:240,&quot;335559739&quot;:240}\">\u00a0<\/span><\/p>\n<h3><span data-ccp-props=\"{&quot;134233117&quot;:false,&quot;134233118&quot;:false,&quot;335559738&quot;:240,&quot;335559739&quot;:240}\">\u00a0<\/span><b><span data-contrast=\"none\">Conclusion<\/span><\/b><span data-ccp-props=\"{&quot;134233117&quot;:false,&quot;134233118&quot;:false,&quot;134245418&quot;:true,&quot;134245529&quot;:true,&quot;335559738&quot;:299,&quot;335559739&quot;:299}\">\u00a0<\/span><\/h3>\n<p><span data-contrast=\"auto\">Index Advisor for Azure DocumentDB\u00a0 brings intelligent, guided performance tuning directly into VS Code. With clear insights, automated index recommendations, and instant performance validation, it helps you optimize your queries quickly and confidently.<\/span><span data-ccp-props=\"{&quot;134233117&quot;:false,&quot;134233118&quot;:false,&quot;335559738&quot;:240,&quot;335559739&quot;:240}\">\u00a0<\/span><\/p>\n<p><div  class=\"d-flex justify-content-center\"><a class=\"cta_button_link btn-primary mb-24\" href=\"https:\/\/marketplace.visualstudio.com\/items?itemName=ms-azuretools.vscode-documentdb\" target=\"_blank\">Ready to try it?<\/a><\/div><\/p>\n<h3 aria-level=\"2\"><b><span data-contrast=\"none\">Join us at Ignite!<\/span><\/b><span data-ccp-props=\"{&quot;134233117&quot;:false,&quot;134233118&quot;:false,&quot;134245418&quot;:true,&quot;134245529&quot;:true,&quot;201341983&quot;:0,&quot;335557856&quot;:16709881,&quot;335559738&quot;:960,&quot;335559739&quot;:360,&quot;335559740&quot;:600}\">\u00a0<\/span><\/h3>\n<p><span data-contrast=\"none\">Microsoft Ignite 2025 is more than just a conference\u2014it\u2019s your gateway to mastering Azure Cosmos DB and DocumentDB for building modern, intelligent applications at scale. From deep-dive sessions and hands-on labs to personalized Expert Meet-ups, you\u2019ll gain practical knowledge, connect with industry leaders, and discover how customers like Sam\u2019s Club, Veeam, and Sitecore are transforming their businesses with these technologies.<\/span><span data-ccp-props=\"{&quot;134233117&quot;:false,&quot;134233118&quot;:false,&quot;201341983&quot;:0,&quot;335557856&quot;:16709881,&quot;335559738&quot;:0,&quot;335559739&quot;:360,&quot;335559740&quot;:360}\">\u00a0<\/span><\/p>\n<p><span data-contrast=\"none\">Whether you\u2019re optimizing performance, enabling real-time analytics, or exploring AI-driven architectures, Ignite gives you the tools and insights to make it happen.<\/span><span data-ccp-props=\"{&quot;134233117&quot;:false,&quot;134233118&quot;:false,&quot;201341983&quot;:0,&quot;335557856&quot;:16709881,&quot;335559738&quot;:0,&quot;335559739&quot;:360,&quot;335559740&quot;:360}\">\u00a0<\/span><\/p>\n<p><span data-contrast=\"none\">Don\u2019t miss out\u2014<\/span><a href=\"https:\/\/ignite.microsoft.com\/\"><span data-contrast=\"none\">start planning your schedule today<\/span><\/a><span data-contrast=\"none\"> and join us to unlock the full potential of Azure Cosmos DB and DocumentDB.<\/span><span data-ccp-props=\"{&quot;134233117&quot;:false,&quot;134233118&quot;:false,&quot;201341983&quot;:0,&quot;335557856&quot;:16709881,&quot;335559738&quot;:0,&quot;335559739&quot;:360,&quot;335559740&quot;:360}\">\u00a0<\/span><\/p>\n<h3 aria-level=\"2\"><strong>About Azure DocumentDB\u00a0<\/strong><\/h3>\n<p><span data-contrast=\"auto\">Azure DocumentDB is a fully managed enterprise-grade MongoDB-compatible database and vector database for modern app development, including AI applications. With its predictable low costs, Open-source project, as well as 99.03% MongoDB compatibility, it is ideal for any MongoDB application running on Azure.<\/span><span data-ccp-props=\"{}\">\u00a0<\/span><\/p>\n<p><div  class=\"d-flex justify-content-center\"><a class=\"cta_button_link btn-primary mb-24\" href=\"https:\/\/aka.ms\/documentdb\" target=\"_blank\">Deploy Azure DocumentDB<\/a><\/div><\/p>\n<h3>About Azure Cosmos DB<\/h3>\n<p>Azure Cosmos DB is a fully managed and serverless NoSQL and vector database for modern app development, including AI applications. With its SLA-backed speed and availability as well as instant dynamic scalability, it is ideal for real-time NoSQL and MongoDB applications that require high performance and distributed computing over massive volumes of NoSQL and vector data.<\/p>\n<p>To stay in the loop on Azure Cosmos DB updates, follow us on <a href=\"https:\/\/twitter.com\/AzureCosmosDB\">X<\/a>, <a href=\"https:\/\/aka.ms\/AzureCosmosDBYouTube\">YouTube<\/a>, and <a href=\"https:\/\/www.linkedin.com\/company\/azure-cosmos-db\/\">LinkedIn<\/a>.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>We\u2019re excited to announce the public preview of Index Advisor for Azure DocumentDB (with MongoDB Compatibility). It is a built-in AI powered performance tuning assistant that helps you understand slow queries, diagnose inefficiencies, and automatically generate optimized index recommendations.\u00a0 With Index Advisor, you can quickly analyze query structure, execution plans, and collection statistics to receive [&hellip;]<\/p>\n","protected":false},"author":125132,"featured_media":11321,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[15],"tags":[],"class_list":["post-11230","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-mongodb-api"],"acf":[],"blog_post_summary":"<p>We\u2019re excited to announce the public preview of Index Advisor for Azure DocumentDB (with MongoDB Compatibility). It is a built-in AI powered performance tuning assistant that helps you understand slow queries, diagnose inefficiencies, and automatically generate optimized index recommendations.\u00a0 With Index Advisor, you can quickly analyze query structure, execution plans, and collection statistics to receive [&hellip;]<\/p>\n","_links":{"self":[{"href":"https:\/\/devblogs.microsoft.com\/cosmosdb\/wp-json\/wp\/v2\/posts\/11230","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\/125132"}],"replies":[{"embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/cosmosdb\/wp-json\/wp\/v2\/comments?post=11230"}],"version-history":[{"count":0,"href":"https:\/\/devblogs.microsoft.com\/cosmosdb\/wp-json\/wp\/v2\/posts\/11230\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/cosmosdb\/wp-json\/wp\/v2\/media\/11321"}],"wp:attachment":[{"href":"https:\/\/devblogs.microsoft.com\/cosmosdb\/wp-json\/wp\/v2\/media?parent=11230"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/cosmosdb\/wp-json\/wp\/v2\/categories?post=11230"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/cosmosdb\/wp-json\/wp\/v2\/tags?post=11230"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}