Critical Description
When optimizer hints are specified, in the explain there is going to be a new section titled "optimizer_hints", which is at the same level as "plan". Currently query workbench only shows the "plan" section of explain text. The new "optimizer_hints" section looks something like:
set query context to "travel-sample.inventory"
explain SELECT /*+ ORDERED */ DISTINCT airline.name FROM route JOIN airport ON airport.faa = route.sourceairport JOIN airline ON route.airline = airline.iata WHERE airport.city = "San Jose" AND airport.country = "United States";
|
"cardinality": 2.475476411638455,
|
"cost": 34242.21823913564,
|
"optimizer_hints": {
|
"hints_followed": [
|
"ORDERED"
|
]
|
},
|
"plan": {
|
"#operator": "Sequence",
|
"~children": [
|
{
|
......
|
}
|
]
|
},
|
"text": "SELECT /*+ ORDERED */ DISTINCT airline.name FROM route JOIN airport ON airport.faa = route.sourceairport JOIN airline ON route.airline = airline.iata WHERE airport.city = \"San Jose\" AND airport.country = \"United States\";"
|
|