Hi,
I'm curious whether I should expect a performance/RU cost benefit if I were to limit my partition key hierarchy to 2 levels rather than the maximum of 3 levels.
E.g. say EntityTypeByProjectId -> DocumentId instead of ProjectId -> EntityType -> DocumentId when I would usually specify 1 part of the 2-level partition key or 2 parts of the 3-level partition key in my queries. The amount of data in the Cosmos collection is the same in both configurations.
Hi, I'm curious whether I should expect a performance/RU cost benefit if I were to limit my partition key hierarchy to 2 levels rather than the maximum of 3 levels.
E.g. say
EntityTypeByProjectId -> DocumentId
instead ofProjectId -> EntityType -> DocumentId
when I would usually specify 1 part of the 2-level partition key or 2 parts of the 3-level partition key in my queries. The amount of data in the Cosmos collection is the same in both configurations.