学软件技术,读第一手资料,去官方网站:MySQL 5.7参考手册
也可以看看比较经典的书籍,如《高性能MySQL》等
1、MySQL官网的难词汇编(glossary)中的聚簇索引(clustered index)的解释
MySQL官网glossary中的clustered index解释的网址,点我呀
clustered index
The InnoDB term for a primary key index. InnoDB table storage is organized based on
the values of the primary key columns, to speed up queries and sorts involving
the primary key columns. For best performance, choose the primary key columns carefully
based on the most performance-critical queries. Because modifying the columns of the
clustered index is an expensive operation, choose primary columns that are rarely
or never updated.
In the Oracle Database product, this type of table is known as an index-organized table.
See Also index, primary key, secondary index.
上面官网中的话,我就解释第一句:clustered index ,The InnoDB term for a primary key index.(聚簇索引,InnoDB术语,表示主键索引)
2、MySQL5.7 官网InnoDB存储引擎中关于聚簇索引(Clustered Indexes)的解释
简单说下如何去一步步找吧,百度MySQL,点击MySQL官网,点击DOCUMENTATION,点击Reference Manual,点击选择5.7版本进入参考手册页
然后依次如下点击, The InnoDB Storage Engine=》 InnoDB On-Disk Structures=》 Indexes=》 Clustered and Secondary Indexes