How MySQL index works under the hood
MySQL indexing works by storing specific data columns in a separate sorted data set that can be used to quickly locate relevant rows in a large table without the need to scan the whole table. This works exactly like the index in a book. If you want to find a specific chapter in the book,…