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];
|
Major