Same result.
Query execution time : 11.83 s
Explain Query :
[{
"#operator": “Sequence”,
"~children": [{
"#operator": “IntersectScan”,
“scans”: [{
"#operator": “IndexScan”,
“index”: “idx_gle_type_balance”,
“keyspace”: “NAV”,
“namespace”: “default”,
“spans”: [{
“Range”: {
“Inclusion”: 1,
“Low”: [
“null”,
“null”
]
}
}],
“using”: “gsi”
}, {
"#operator": “IndexScan”,
“index”: “idx_GLE_Type”,
“keyspace”: “NAV”,
“namespace”: “default”,
“spans”: [{
“Range”: {
“High”: [
"“GLEntry”"
],
“Inclusion”: 3,
“Low”: [
"“GLEntry”"
]
}
}],
“using”: “gsi”
}]
}, {
"#operator": “Parallel”,
"~child": {
"#operator": “Sequence”,
"~children": [{
"#operator": “Fetch”,
“as”: “X”,
“keyspace”: “NAV”,
“namespace”: “default”
}, {
"#operator": “Filter”,
“condition”: “((((X.Type) = “GLEntry”) and ((X.Balance) is not missing)) and ((X.No_) is not missing))”
}, {
"#operator": “InitialGroup”,
“aggregates”: [
“sum((X.Balance))”
],
“group_keys”: [
"(X.No_)"
]
}]
}
}, {
"#operator": “IntermediateGroup”,
“aggregates”: [
“sum((X.Balance))”
],
“group_keys”: [
"(X.No_)"
]
}, {
"#operator": “FinalGroup”,
“aggregates”: [
“sum((X.Balance))”
],
“group_keys”: [
"(X.No_)"
]
}, {
"#operator": “Parallel”,
"~child": {
"#operator": “Sequence”,
"~children": [{
"#operator": “InitialProject”,
“result_terms”: [{
“as”: “No_”,
“expr”: “(X.No_)”
}, {
“as”: “Balance”,
“expr”: “ifnull(sum((X.Balance)), 0)”
}]
}, {
"#operator": “FinalProject”
}]
}
}]
}]