This repository was archived by the owner on Jul 19, 2024. It is now read-only.
Would the number of partition key levels impact performance? #2
Description
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.