{ "plan": { "#operator": "Sequence", "~children": [ { "#operator": "IndexScan3", "as": "d", "covers": [ "cover (`t`)", "cover ((`d`.`name`))", "cover ((`d`.`age`))", "cover ((meta(`d`).`id`))", "cover (min(cover ((`d`.`age`))))" ], "filter_covers": { "cover (((`d`.`travel_history`) < {}))": true, "cover (([] <= (`d`.`travel_history`)))": true, "cover (is_array((`d`.`travel_history`)))": true }, "index": "travel_history_name_age", "index_group_aggs": { "aggregates": [ { "aggregate": "MIN", "depends": [ 2 ], "expr": "cover ((`d`.`age`))", "id": 4, "keypos": 2 } ], "depends": [ 2 ] }, "index_id": "b843f9bffc0ed1dd", "index_projection": { "entry_keys": [ 4 ] }, "keyspace": "default", "namespace": "default", "spans": [ { "exact": true, "range": [ { "high": "\"India\"", "inclusion": 3, "low": "\"India\"" } ] } ], "using": "gsi" }, { "#operator": "Parallel", "~child": { "#operator": "Sequence", "~children": [ { "#operator": "InitialProject", "result_terms": [ { "expr": "cover (min(cover ((`d`.`age`))))" } ] }, { "#operator": "FinalProject" } ] } } ] }, "text": "SELECT MIN(d.age) from default d USE INDEX (`travel_history_name_age`) UNNEST d.`travel_history` AS t where t = 'India'" }