Details
-
Task
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
Description
Example:
"table": "lineitem",
|
"best_access_path": {
|
"considered_access_paths": [
|
{
|
"access_type": "ref",
|
"index": "PRIMARY",
|
"rows": 1,
|
"cost": 250.69,
|
"chosen": true
|
},
|
{
|
"access_type": "ref",
|
"index": "i_l_orderkey",
|
"rows": 1,
|
"cost": 498.4,
|
"chosen": false,
|
"cause": "cost"
|
},
|
{
|
"access_type": "ref",
|
"index": "i_l_orderkey_quantity",
|
"rows": 1,
|
"cost": 498.4,
|
"chosen": false,
|
"cause": "cost"
|
},
|
{
|
"type": "scan",
|
"chosen": false,
|
"cause": "cost"
|
}
|
]
|
So here we see all the ref accesses and table_scan considered on table lineitem, just add the best access picked to the optimizer trace to make it clear
Attachments
Issue Links
- relates to
-
-
- Closed
-
-
MDEV-20443 More information regarding access of a table to be printed inside the optimizer_trace
-
- Closed
-