N1ql array index performance

I think N1QL can not solve this problem.
and FYI