Box 1 = Range

Azure Cosmos DB supports three types of indexes: range, spatial and composite. For the query you

provided, which is an equality query on a single property, the best type of index to use

is range. Range index is based on an ordered tree-like structure and it is used for equality queries,

range queries and checking for the presence of a property1. Range index also supports any string or

number2.

Box 2 = Composite

Azure Cosmos DB supports three types of indexes: range, spatial and composite. For the query you

provided, which is an order by query on two properties, the best type of index to use

is composite. Composite index is used for optimizing order by queries on multiple

properties1. Composite index allows you to specify a list of property paths and sort orders that are

used for ordering items2.

Box 3 = spatial

Azure Cosmos DB supports three types of indexes: range, spatial and composite. For the query you

provided, which is a spatial query on a point property, the best type of index to use is spatial. Spatial

index is used for querying items based on their location or proximity to a given point1. Spatial index

supports point, polygon and linestring data types2.