Hello @vsr1! The query you provided has similar execution times to the first one, so no noticeable improvements (yesterday the system was under high load, now both queries run between 1.5-3s).
I guess there must be something we’re not doing correctly. With a fairly low cardinality of documents (in the tens of thousands), should we expect a query to take this long with proper indices?
As for your last comment, I am not sure what you mean by “original queries”, could you elaborate? Also, the 4.6.0 is a Developer Preview (Community Edition), meaning that may not be possible to upgrade at this time. Thank you for your help, looking forward for your feedback!