@vsr1 is it possible to create an index and to define the order with NULLS LAST?
for example, I tried
filed 1 DESC NULLS LAST
) WHERE (type
= "foo"); and I get an error with the message: “syntax error - at NULLS”,`
the reason I am asking is that if I use the order by field DESC NULLS LAST in a query the orde by doesn’t use the query. If I just use order by field DESC, then N1QL use the index and I get the result in ms instead of seconds.
Can this type of filter be done somehow?