dongyong3590 2014-03-11 00:22
浏览 171
已采纳

什么是KEY for MySQL的'_idx'后缀?

Tried searching for this but couldn't find anything that helped me understand.

In CodeIgniter's Session table creation query for example, there's a line:

KEY `last_activity_idx` (`last_activity`)

that comes after defining the column 'last_activity'.

What's this for?

  • 写回答

1条回答 默认 最新

  • duanjian4698 2014-03-11 00:26
    关注

    That means the column last_activity is indexed, and the name of the index is last_activity_idx. An index means that running conditional queries based on that field will be faster.

    For example, if you run a query like:

    SELECT * FROM `session_table` WHERE `last_activity` = 1000
    

    If the column is not indexed, MySQL will have to search through every row to check the value of that column. If that column is indexed, MySQL is able to more quickly find rows which match that column.

    https://dev.mysql.com/doc/refman/5.5/en/optimization-indexes.html

    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论

报告相同问题?

悬赏问题

  • ¥15 求chat4.0解答一道线性规划题,用lingo编程运行,第一问要求写出数学模型和lingo语言编程模型,第二问第三问解答就行,我的ddl要到了谁来求了
  • ¥15 Ubuntu在安装序列比对软件STAR时出现报错如何解决
  • ¥50 树莓派安卓APK系统签名
  • ¥15 maple软件,用solve求反函数出现rootof,怎么办?
  • ¥65 汇编语言除法溢出问题
  • ¥15 Visual Studio问题
  • ¥20 求一个html代码,有偿
  • ¥100 关于使用MATLAB中copularnd函数的问题
  • ¥20 在虚拟机的pycharm上
  • ¥15 jupyterthemes 设置完毕后没有效果