Details
Description
cbq> CREATE INDEX join_index0 ON default(tasks_ids);
{
"request_id": "3efb1dcd-7b23-45d4-b694-d8c79815429e",
"signature": null,
"results": [
],
"status": "success",
"metrics":
}
cbq> EXPLAIN SELECT emp.name, task FROM default emp UNNEST emp.tasks_ids task;
{
"request_id": "69cd9e15-d624-4839-8da9-c1cc0ca6cfea",
"signature": "json",
"results": [
{
"#operator": "Sequence",
"~children": [
,
{
"#operator": "Parallel",
"~child": {
"#operator": "Sequence",
"~children": [
,
,
{
"#operator": "InitialProject",
"result_terms": [
,
{ "expr": "`task`" } ]
},
]
}
}
]
}
],
"status": "success",
"metrics":
}
cbq>