You store product reviews in a document database. Each review includes `user_id`, `product_id`, `rating`, and `comment`. You frequently query by `product_id` and sort by `rating`.Which design choices improve query performance?

Question

Answer

Create a compound index on `product_id` and `rating`

Answer

Store reviews in separate collections per product

Answer

Use embedded documents for user details

Answer

Use text indexes on `comment` field

Crowdly

You store product reviews in a document database. Each review includes `user_id`...

Want instant access to all verified answers on moovit.vit.ac.in?