Description
CREATE INDEX ixd2 ON default (DISTINCT ARRAY [op.name, META().id] FOR op IN OBJECT_PAIRS(META().id) END); |
EXPLAIN SELECT META(d).id AS id FROM default AS d UNNEST OBJECT_PAIRS(META(d).id) AS op WHERE [op.name, META(d).id] > [1,10]; |
Above one is not selecting index.
Below query META(d).id replaced with op.id it works
CREATE INDEX ixd1 ON default (DISTINCT ARRAY [op.name, op.id] FOR op IN OBJECT_PAIRS(META().id) END); |
EXPLAIN SELECT META(d).id AS id FROM default AS d UNNEST OBJECT_PAIRS(META(d).id) AS op WHERE [op.name, op.id] > [1,10]; |