Long query exec time despite using index

SQL++
2

Plan looks right.

  1. Check your ANY clause according to How to correctly create array index. Check you need array indexing can this apply post index scan.
  2. This is minor instead of negative score, Use score DESC in the index and query
  3. use profiling to find out where it taking time https://blog.couchbase.com/optimize-n1ql-performance-using-request-profiling/