Description
Index created:
|
CREATE INDEX `idxtasks0` ON `default`((`tasks`[0]),`department`)
|
|
Query Issued:
|
explain select meta().id from default WHERE tasks[0]="Sales" AND NOT (department = 'Manager') limit 10;
|
|
Result shown in json:
|
"plan": {
|
"#operator": "Sequence",
|
"~children": [
|
{
|
"#operator": "Sequence",
|
"~children": [
|
{
|
"#operator": "DistinctScan",
|
"scan": {
|
"#operator": "IndexScan",
|
"covers": [
|
"cover (((`default`.`tasks`)[0]))",
|
"cover ((`default`.`department`))",
|
"cover ((meta(`default`).`id`))"
|
],
|
"index": "idxtasks0",
|
"index_id": "207a0e77687b66c7",
|
"keyspace": "default",
|
"limit": "10",
|
"namespace": "default",
|
"spans": [
|
{
|
"Range": {
|
"High": [
|
"successor(\"Sales\")",
|
"\"Manager\""
|
],
|
"Inclusion": 0,
|
"Low": [
|
"\"Sales\"",
|
"null"
|
]
|
}
|
},
|
{
|
"Range": {
|
"High": [
|
"successor(\"Sales\")"
|
],
|
"Inclusion": 0,
|
"Low": [
|
"\"Sales\"",
|
"\"Manager\""
|
]
|
}
|
}
|
],
|
"using": "gsi"
|
}
|
},
|
|
|
|
Result shown in plan tab:
|
Query Plan Summary:
|
|
Indexes used:
|
Buckets used:
|
default
|
Fields used:
|
default.tasks[0]
|
default.department
|
|
|
Query Operator Data Flows (bottom to top):
|
|
Limit 10
|
FinalProject
|
InitialProject 1 terms
|
Filter
|
DistinctScan
|
|
|
Indexes used are empty.
|
|
|
|