How to Efficiently Use Indexes in MySQL

Are you building applications that utilize MySQL as the backend layer? Are you bulding a new application from groundup? Or do you want to solve the performance issues with an existing application? Do you want to learn how to make MySQL access efficient? Either way, the most important aspect of efficient MySQL usage is learning how to do indexing properly.

Indexes are what allow MySQL to efficiently retreive data, that in turns improves performance and reduces infrastructure costs.

We will explain how MySQL stores data in indexes and how it uses it for data access. We will be reviewing the most typical use-cases where indexes are hugely beneficial. Each use-case will be illustrated with examples so that you can quickly build high-performance applicaitons.