Question

A gaming company stores player match records in a Cosmos DB for NoSQL container. Each document has properties: playerId, region, and score. The analytics team needs a query that returns, for a given region, only the three documents with the highest scores. They want to minimize RU consumption and avoid pulling back all matching documents to the client for sorting. Which single query approach best meets this requirement?

Accepted Answer

SELECT TOP 3 c.playerId, c.score FROM c WHERE c.region = 'EU' ORDER BY c.score DESC

Answer

SELECT c.playerId, c.score FROM c WHERE c.region = 'EU' and then sort and slice the results in application code

Answer

SELECT VALUE MAX(c.score) FROM c WHERE c.region = 'EU'

Answer

SELECT c.playerId, c.score FROM c WHERE c.region = 'EU' ORDER BY c.score DESC OFFSET 0 LIMIT 3, using a separate query per playerId