MySQL优化之索引覆盖
有两种索引,聚簇索引和非聚簇索引。假设我们有表tabA,字段:id(主键自增),name,address其中主键id采用的就是聚簇索引。如果我们将name设为索引:ALTER TABLE tabA ADD INDEX (name);则为非聚簇索引。
给我一分钟,让你彻底明白MySQL聚簇索引和非聚簇索引
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 queri