Is it possible to filter in a single query on multiple independent indexes ?
If I have
select from dealer
WHERE city = 'wellington'
AND name = 'james'
where each city and name are separate indexes, is it possible to query on it and orientdb use both of the indexes ? Currently when running explain I see only one index being used, is it possible for orient to use both ?
I know that I can use compound indexes but in my real case scenario I am trying to query both the lucene spatial and nounique index and I can't compound those.
Thanks