create index ix101 ON default (DISTINCT ARRAY v.id FOR v IN a1 END);
|
explain SELECT META().id FROM default WHERE ANY v IN a1 SATISFIES v.id BETWEEN 10 AND 20 END;
|
Above Index and query combination uses Implicit covered array index.
But not the below combination. The array key is array
create index ix102 ON default (DISTINCT ARRAY [v.id] FOR v IN a1 END);
|
explain SELECT META().id FROM default WHERE ANY v IN a1 SATISFIES [v.id] BETWEEN [10] AND [20] END;
|
If we transform BETWEEN like below it uses Implicit covered array index.
explain SELECT META().id FROM default WHERE ANY v IN a1 SATISFIES [v.id] BETWEEN [10] AND [20] END;
|
Improvement
Major