HI, I know this question as alredy been posted but I cannot find a good answer. I have this query SELECT * FROM store WHERE _type=“Product” ORDER BY updated LIMIT 30 which take 4.8s with 70k products. If I remove the order by clause the time is ~9ms I have this indexes: CREATE INDEX ALL__typ…

N1ql 4.5 order by performance

geraldss October 31, 2016, 3:20pm 2

Add to your query WHERE clause.

AND updated IS NOT NULL