Question

A high-throughput order-ingestion container writes 5,000 documents per second. Each document has 60 properties, but analysts only ever filter and sort on 4 of them: orderStatus, customerId, orderDate, and region. The team notices write RU charges are very high and wants to reduce them without breaking the analyst queries. What indexing policy change should they apply?

Accepted Answer

Set includedPaths to explicitly list only the 4 queried property paths and add '/*' to excludedPaths to exclude everything else.

Answer

Set the indexing mode to 'none' so that no properties are indexed, eliminating index maintenance overhead on writes.

Answer

Set includedPaths to '/*' and add the 4 queried properties to excludedPaths so only those are indexed.

Answer

Keep the default indexing policy but increase provisioned throughput so writes no longer throttle.