当前位置：Gxlcms >
数据库问题 >
MySQL-Comparison of B-Tree and Hash Indexes
MySQL-Comparison of B-Tree and Hash Indexes
时间：2021-07-01 10:21:17
帮助过：2人阅读
PRIMARY KEY
, UNIQUE
, INDEX
, and FULLTEXT
) are stored in B-trees
. Exceptions: Indexes on spatial data types use R-trees; MEMORY
tables also support hash indexes
; InnoDB
uses inverted lists for FULLTEXT
indexes.
没多少内容，直接看原文吧
http://dev.mysql.com/doc/refman/5.7/en/index-btree-hash.html
、只要使用了Limit mysql 会尽力使用索引、
MySQL-Comparison of B-Tree and Hash Indexes
标签：
