Index

Tagged

A collection of 2 posts

Part II: How Indexes Work In Mysql

In the first part of the article series, we understood what indexes are and how indexes work internally. In this part, we will look into multi-columnar indexes, ordering in indexes, and pitfalls in using indexes. We know that MySQL will only use one index per table per query. Therefore, if

Database

How Do Indexes Work In Mysql?

In this article series, we will dig deep into what indexes are, how it works, what are the advantages and disadvantages of using an index, multi-column indexes, and what are the pitfalls or gotchas of using an index. We have often come across the example of the index in a