Vikas Gupta: Software architect

  • Vikas Gupta

  • Enter your email address to follow this blog and receive notifications of new posts by email.

    Join 21 other followers

  • Archives

  • Start here

  • Advertisements

Posts Tagged ‘Databases MySql’

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 »


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