Clarification for composite indexes

[bexxx]

When using a query with a filter (name = "foo") and multiple sort orders (order by c.created asc, c.color), there must be two compound indexes added. One for the order and one for the filter with order (and in this order), otherwise querying the DB will fail with an error. Please clarify this in the docs. Also it is not really clear, that those property paths must be case sensitive.

---

Document Details

⚠ Do not edit this section. It is required for learn.microsoft.com ➟ GitHub issue linking.

• ID: f1c7d0e0-b932-085e-6816-0b2219a1f37b
• Version Independent ID: b463dc0b-313c-d90a-b8aa-c2b64004f812
• Content: Manage indexing policies in Azure Cosmos DB
• Content Source: articles/cosmos-db/nosql/how-to-manage-indexing-policy.md
• Service: cosmos-db
• Sub-service: nosql
• GitHub Login: @seesharprun
• Microsoft Alias: sidandrews

[shaktisingh-msft]

Hi @bexxx ,

Thanks for sharing this feedback. We will look into this and update as appropriate.

Hi @seesharprun,

Could you please look into this request, thanks.