Arango AQL use index to search for existing property

Question

I want to get all object with available property "available"

For u in col
filter u.available!= null
return u

But the above query would not use index even if u.available is indexed. How can I iterate with the use of index?

Can you share your index definitions and the explain output? FWIW: if you don't care about documents where this field is null or not available, I would recommend to use a sparse index. — mpoeter, Apr 27 '20 at 07:24

score -1 · Accepted Answer · answered Apr 27 '20 at 14:37

-1

With comment from @mpoeter , I can create an index that are specifically spare to force arango to use index.

answered Apr 27 '20 at 14:37

Loredra L

1 Answers1