mysql btree index on InnoDB tables?

Question

Do InnoDB tables already contain a b tree? Or was i reading something wrong?

Jon Black · Accepted Answer · 2010-11-30 12:13:31Z

1

innodb tables have a special kind of primary key index called a clustered b-tree index which can make well a well designed innodb table very fast to query.

following resources may be of interest:

http://dev.mysql.com/doc/refman/5.0/en/innodb-index-types.html

http://www.xaprb.com/blog/2006/07/04/how-to-exploit-mysql-index-optimizations/

answered Nov 30, 2010 at 12:13

Jon Black

16.6k5 gold badges45 silver badges42 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

xxmajia · Accepted Answer · 2015-10-18 15:56:11Z

0

should be b+ tree, not b tree according to: this

answered Oct 18, 2015 at 15:56

xxmajia

7288 silver badges6 bronze badges

Collectives™ on Stack Overflow

mysql btree index on InnoDB tables?

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related