Description
As Prasad Varakur found, this scenario has a gap in covering array index. cc Sitaram Vemulapalli
CREATE INDEX isched_c |
ON `travel-sample`(DISTINCT ARRAY i.flight FOR i IN schedule END) |
WHERE (type = "route") ; |
|
EXPLAIN SELECT meta().id FROM `travel-sample` |
USE INDEX(isched_c) |
WHERE ANY i IN schedule SATISFIES i.flight LIKE "UA%" END |
AND type = "route"; |