Question

You are designing a product catalog container in Azure Cosmos DB for NoSQL. The container is partitioned on /categoryId. Your most frequent operation is retrieving a single product where the application already knows both the product's id and its categoryId. This lookup happens millions of times per day, and you want to minimize RU consumption. Which approach should you use to retrieve the product?

Accepted Answer

Use a point read (ReadItem) supplying both the item id and the categoryId partition key value.

Answer

Execute a SQL query: SELECT * FROM c WHERE c.id = @id, letting Cosmos DB fan out across partitions.

Answer

Execute a SQL query: SELECT * FROM c WHERE c.id = @id AND c.categoryId = @categoryId within the partition.

Answer

Create a stored procedure that scans the partition and returns the matching product.