Compound indexes are required for efficiently sorting on multiple fields. See https://docs.mongodb.com/manual/tutorial/sort-results-with-indexes/.
This feature is now available. To learn more about this feature and our overall wire protocol support for MongoDB API please see, https://docs.microsoft.com/en-us/azure/cosmos-db/mongodb-feature-support.
Thank you for your suggestion and votes.
Can you explain how to enable this change? I've tried my test case against a new CosmosDB, and I still see issues where Azure CosmosDB does *not* respect compound constraints in the same way MongoDB does.
Undefined collection is created while setting TTL via mongoose and TTL also not working