IT博客汇
  • 首页
  • 精华
  • 技术
  • 设计
  • 资讯
  • 扯淡
  • 权利声明
  • 登录 注册

    MySQL 5.6 Database Administrator-093-Which statement best describes the meaning of the value for the key_len column?

    royalwzy发表于 2015-09-03 12:55:39
    love 0
    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? A. It shows the total size of the index row. B. It shows how many columns in the index are examined. C. It shows the number of characters indexed in the key. D. It shows how many bytes will be used from each index row. 答案:D


沪ICP备19023445号-2号
友情链接