Thursday, 15 March 2012

database - mysql primary key,is it a hash index or b-tree? -


The primary key is created automatically and there is an index "primary" in it, it is a hash or b-tree.

The CB-Tree is bound and not hash.

Therefore, if it is a "primary" B-tree, I can ask it with a category selection.

As long as you have the MEMORY access method, the form of your MySQL indexed BTRI Are organized in and class scans can be suitable for query.


No comments:

Post a Comment