We are using Azure Cosmos DB, Azure cosmos SDK v3.35.4, .Net core 7.
In our data one of the columns values is distinct number like 1,2,3,4,…., 7869,….,34562,34563,……… So we created a ‘range’ property in our C# Model which represent range. Example 1-1000 is range=1, 1001-2000 is range=2 etc.
Example:
We insert this ‘range’ property in cosmos container as well and defined it as PartitionKey too. Means for CRUD operations we use this PartitionKey as well
We checked our Azure cosmos DB insights on azure portal for our container
ONLY 1 physical partition is being used? What i did wrong in selecting my Partition key?