Hi @hanswong
This is a different issue from the earlier discussions in this post, since your query doesn’t use a count. Please open a different forum question for this with the issue, version of couchbase. (I assume that you are facing a performance issue ? )
You could also take a look at the following thread to see if you can improve the performance of your query. (if that is the issue you are facing)
https://www.couchbase.com/forums/t/performance-drop-when-system-is-under-load/
Thanks