This query has an index scan timeout:
explain select * from bugsentry where skuId = 1027 and submitTime > ‘2016-03-08’ and categoryId = ‘0xfffffe’;
{
“requestID”: “eb27c579-33de-45d3-ae5b-e49cc90f2818”,
“signature”: “json”,
“results”: [
{
"#operator": “Sequence”,
"~children": [
{
"#operator": “IndexScan”,
“index”: “1027_reports”,
“keyspace”: “bugsentry”,
“limit”: 9.223372036854776e+18,
“namespace”: “default”,
“spans”: [
{
“Range”: {
“High”: null,
“Inclusion”: 0,
“Low”: [
"“2016-03-08"”
]
},
“Seek”: null
}
],
“using”: “gsi”
},
{
"#operator": “Parallel”,
"~child": {
"#operator": “Sequence”,
"~children": [
{
"#operator": “Fetch”,
“keyspace”: “bugsentry”,
“namespace”: “default”
},
{
"#operator": “Filter”,
“condition”: “((((bugsentry
.skuId
) = 1027) and (“2016-03-08” \u003c (bugsentry
.submitTime
))) and ((bugsentry
.categoryId
) = “0xfffffe”))”
},
{
"#operator": “InitialProject”,
“result_terms”: [
{
“star”: true
}
]
},
{
"#operator": “FinalProject”
}
]
}
}
]
}
],
“status”: “success”,
“metrics”: {
“elapsedTime”: “17.191286ms”,
“executionTime”: “16.652251ms”,
“resultCount”: 1,
“resultSize”: 2066
}
}
This query does not:
cbq> explain select * from bugsentry where skuId = 1027 and submitTime > ‘2016-03-08’;
{
“requestID”: “82afc3b3-d87f-40a8-8313-b792b55c348f”,
“signature”: “json”,
“results”: [
{
"#operator": “Sequence”,
"~children": [
{
"#operator": “IndexScan”,
“index”: “1027_reports”,
“keyspace”: “bugsentry”,
“limit”: 9.223372036854776e+18,
“namespace”: “default”,
“spans”: [
{
“Range”: {
“High”: null,
“Inclusion”: 0,
“Low”: [
"“2016-03-08"”
]
},
“Seek”: null
}
],
“using”: “gsi”
},
{
"#operator": “Parallel”,
"~child": {
"#operator": “Sequence”,
"~children": [
{
"#operator": “Fetch”,
“keyspace”: “bugsentry”,
“namespace”: “default”
},
{
"#operator": “Filter”,
“condition”: “(((bugsentry
.skuId
) = 1027) and (“2016-03-08” \u003c (bugsentry
.submitTime
)))”
},
{
"#operator": “InitialProject”,
“result_terms”: [
{
“star”: true
}
]
},
{
"#operator": “FinalProject”
}
]
}
}
]
}
],
“status”: “success”,
“metrics”: {
“elapsedTime”: “3.70378ms”,
“executionTime”: “3.652419ms”,
“resultCount”: 1,
“resultSize”: 2016
}
}