Articles

 B-TREE and B+TREE Index (Part 2)

When you hear in the industry the word index, they often mean a B-tree index. Most of the MySQL...

 Clustered Index - keypoints, advantages and disadvantages (Part 3)

Clustered index - keypoints Clustered index is just a different approach of data storage. This...

 Creating Indexes for a table (Part 7)

Now, we will further continue with this demonstration and create indexes on the table film. Here...

 Hash Index (Part 4)

Hash index Just like B-tree index, we also have a concept of a hash index. A hash index is...

 Indexing Strategies for High Performance (Part 6)

Indexes are called keys in MySQL. They are data structures that storage engines use to find rows...

 InnoDB versus MyISAM (Part 1)

Below we want to outline differences between InnoDB and MyIsam engine in mysql.   InnoDB...

 Other type of indexes (Part 5)

Other indexes. MySQL is open source and you can use different kinds of storage engines with...