Consider the following: Mysql EXPLAIN SELECT * FROM City WHERE Name = `Jacksonville' AND CountryCode = `USA' \G ******************************** 1. row ******************************** Id: 1 Select_type: SIMPLE Table: City Type: ref Possible_keys: name_country_index Key: name_country_index Ref: const, const Rows: 1 Extra: Using where Which statement best describes the meaning of the value for the key_len column?

Question

Consider the following:

Mysql> EXPLAIN SELECT * FROM City WHERE Name = Jacksonville' AND CountryCode = USA' \G ******************************** 1. row ******************************** Id: 1 Select_type: SIMPLE Table: City Type: ref Possible_keys: name_country_index Key: name_country_index Ref: const, const Rows: 1 Extra: Using where Which statement best describes the meaning of the value for the key_len column?

Accepted Answer

D. It shows how many bytes will be used from each index row.

Answer

A. It shows the total size of the index row.

Answer

B. It shows how many columns in the index are examined.

Answer

C. It shows the number of characters indexed in the key.

Consider the following: Mysql> EXPLAIN SELECT FROM City WHERE Name = Jacksonville' AND CountryCode = USA' \G 1. row * Id: 1 Select_type…

Question

Options

How the community answered

Community Discussion