I have more than a billion records in collection, I would like to know the performance of the cts.jsonPropertyRangeQuery and cts.jsonPropertyValueQuery.
I need to query this much data very frequently, so please suggest which type of query is good for my requirement.
If your query is specifying a value, use the query construct for a value. Don’t overthink it.
The one exception is if you’re passing a lot of values with one OR query. Then you should test if with your dataset doing an OR of many value queries or a range query with a list does better.
