Vikas Gupta: Software architect

Archive for December, 2012

B-Tree Index in MySql

Posted by Vikas Gupta on December 17, 2012

Indexes in MySql works like an index in a book. While, indexes in a book tell you about the pages on which a term occurs, indexes in MySql tell you the rows that contain the matching data. An index contains values from one or more columns in a table. If you index more than one column, the column order is very important, because MySQL can only search efficiently on a leftmost prefix of the index. Creating an index on two columns is not the same as creating two separate single-column indexes. In this post, I will discuss about B-Tree index and it’s working in MySql. Read the rest of this entry »

Advertisements

Posted in Databases, MySQL | Tagged: | Leave a Comment »