|
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
|