Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

聚集索引与非聚集索引区别 #565

Open
haitai111 opened this issue Aug 17, 2017 · 0 comments
Open

聚集索引与非聚集索引区别 #565

haitai111 opened this issue Aug 17, 2017 · 0 comments

Comments

@haitai111
Copy link

http://blog.codinglabs.org/articles/theory-of-mysql-index.html
中提到MyISAM的索引方式也叫做“非聚集”的,InnoDB的索引方式是“聚集的”。从这两者对比中,自己的感觉是“非聚集索引”是指索引和数据分离(索引保存了数据的地址),“聚集索引”是指索引和数据一起(索引文件就是数据文件)。
可是自己在另一篇博客中看到:http://www.cnblogs.com/aspnethot/articles/1504082.html
聚集索引:该索引中键值的逻辑顺序决定了表中相应行的物理顺序。
非聚集索引: 一种索引,该索引中索引的逻辑顺序与磁盘上行的物理存储顺序不同。

所以,我想知道的是这两种说法是不是都正确??它们两者有对应关系吗?

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant