MySQL Forums
Forum List  »  Optimizer & Parser

Explain features
Posted by: Michael Bialik
Date: March 29, 2020 01:29PM

Hi.
I'm posting a simple explain:

explain format= json select * from sakila.actor a
{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "21.00"
},
"table": {
"table_name": "a",
"access_type": "ALL",
"rows_examined_per_scan": 200,
"rows_produced_per_join": 200,
"filtered": "100.00",
"cost_info": {
"read_cost": "1.00",
"eval_cost": "20.00",
"prefix_cost": "21.00",
"data_read_per_join": "54K"
},
"used_columns": [
"actor_id",
"first_name",
"last_name",
"last_update"
]
}
}
}

As you can see there is no mentioning of schema name [sakila] and the original table name [actor] in the explain text (table alias is used instead.

Is it possible to display these values as part of explain?

Options: ReplyQuote


Subject
Views
Written By
Posted
Explain features
134
March 29, 2020 01:29PM
53
March 29, 2020 02:01PM


Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.