Description
create index i3 on `beer-sample`(meta().id, city);
explain select city from `beer-sample` where meta().id >= "M" limit 10; This LIMIT isn’t pushed to index scan. If I create index on other fields city/etc alone, that LIMIT gets pushed down.
[
{
"plan": {
"#operator": "Sequence",
"~children": [
{
"#operator": "Sequence",
"~children": [
{
"#operator": "IndexScan",
"covers": [
"cover ((meta(`beer-sample`).`id`))",
"cover ((`beer-sample`.`city`))",
"cover ((meta(`beer-sample`).`id`))"
],
"index": "i3",
"index_id": "b21159b6dc4e192",
"keyspace": "beer-sample",
"namespace": "default",
"spans": [
{
"Range":
}
],
"using": "gsi"
},
{
"#operator": "Parallel",
"~child": {
"#operator": "Sequence",
"~children": [
,
{
"#operator": "InitialProject",
"result_terms": [
]
},
]
}
}
]
},
]
},
"text": "select city from `beer-sample` where meta().id >= \"M\" limit 10;"
}
]