@Oren_Deri, apologies for the delay.
There are a few things you need to know when comparing single node deployment to relational databases. I have posted a similar response here.
A few additional questions on your query;
- Have you looked at the max_parallelism setting. To utilize the “Parallel” operator, you need to set your parallelism using the following flag; http://developer.couchbase.com/documentation/server/4.0/n1ql/n1ql-rest-api/executen1ql.html
- Do you need all attributes with “select *” or can you cover this query by including a few more attributes in in the index from the documents?
thanks
-cihan