Have a question regarding order of the index in the query.
lets say i have an index that covers the following fields, in this exact order in the index.
a, b, c.
I want to query on a and for this particular query c as well. I know in n1ql by adding the b in between would improve the result of this query, because it follows the form of the index. and I can simply suggest AND
b IS NOT MISSING.
My problem is there is a chance b can be missing. Is it possible for me to include b in the query but not care whether it is there or not? outside of doing AND ((
b IS NOT MISSING ) OR (
b IS MISSING))