PHP Interview Questions(9)

面试时间:2019 年 3 月 22 日,星期五,下午四点。


审批流程数据库设计

https://www.cnblogs.com/yyy116008/p/8330076.html

MySQL 索引数据结构

Most MySQL indexes (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.

 b-tree 和 b+tree 的区别

B-Tree
B+Tree

非聚集索引和聚集索引的区别

MySQL MyISAM Primary Key(非聚集索引)
MySQL MyISAM Secondary Key(非聚集索引)
MySQL InnoDB Primary Key(聚集索引)
MySQL InnoDB Secondray Key(聚集索引)

参考:

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

http://blog.codinglabs.org/articles/theory-of-mysql-index.html

 400 total views,  1 views today

Leave a Reply

Your email address will not be published. Required fields are marked *