Mysql Index Tutorial | [Simple Explanation] [2020]

In this video, we’ll see how basic Mysql Index concept works. We’ll see how Mysql B-Tree index concept works with a simple example.

Power of Mysql Index: https://www.youtube.com/watch?v=MS70fZbOuqo

Mysql Index works similar to how an index in a Book works. Mysql Indexes stored indexed column data in a separate storage in an Ordered List. When we search for a value, Mysql searches in the index column using the B-tree concept.

Mysql B-tree index works by first checking the middle value in the ordered indexed column, if the value is greater, it will continue to search on the right side of the column. If the value is lesser than the the middle value, it will search to left of the column. This method of search continues till it matches the value. This way, indexed columns need not scan all the rows of the table.

SUBSCRIBE: https://www.youtube.com/channel/UCvrnQcFaGHw0kwm9chkzXtw?sub_confirmation=1