Could you please post the sample document and index definition.
NOTE: Predicate date LIKE “%06/07/2017%” AND id IS NOT MISSING requires full index scan on the whole index (due to leading %). i.e. 10 million documents. On top it needs to GROUP BY.
Could you please post the sample document and index definition.
NOTE: Predicate date LIKE “%06/07/2017%” AND id IS NOT MISSING requires full index scan on the whole index (due to leading %). i.e. 10 million documents. On top it needs to GROUP BY.