Details
-
Improvement
-
Resolution: Won't Fix
-
Major
-
5.0.0
Description
create index ix1 on default(distinct pairs(self)); |
explain select 1 from default where a > 1; |
{
|
"requestID": "725dafaa-9783-457f-85f7-88262dd4de17", |
"signature": "json", |
"results": [ |
{
|
"plan": { |
"#operator": "Sequence", |
"~children": [ |
{
|
"#operator": "DistinctScan", |
"scan": { |
"#operator": "IndexScan2", |
"index": "ix1", |
"index_id": "b137a24c892a3237", |
"index_projection": { |
"primary_key": true |
},
|
"keyspace": "default", |
"namespace": "default", |
"spans": [ |
{
|
"exact": true, |
"range": [ |
{
|
"high": "[successor(\"a\")]", |
"inclusion": 0, |
"low": "[\"a\", 1]" |
}
|
]
|
}
|
],
|
"using": "gsi" |
}
|
},
|
{
|
"#operator": "Fetch", |
"keyspace": "default", |
"namespace": "default" |
},
|
{
|
"#operator": "Parallel", |
"~child": { |
"#operator": "Sequence", |
"~children": [ |
{
|
"#operator": "Filter", |
"condition": "(1 < (`default`.`a`))" |
},
|
{
|
"#operator": "InitialProject", |
"result_terms": [ |
{
|
"expr": "1" |
}
|
]
|
},
|
{
|
"#operator": "FinalProject" |
}
|
]
|
}
|
}
|
]
|
},
|
"text": "select 1 from default where a > 1;" |
}
|
],
|
"status": "success", |
"metrics": { |
"elapsedTime": "4.799717ms", |
"executionTime": "4.782702ms", |
"resultCount": 1, |
"resultSize": 2514 |
}
|
}
|