Devising the Perfect Index for Your Use Case – MySQL Edition

 dans Sites anglophones  étiqueté B-Tree Indexes / Blogs / Clustered Index / Composite Index / covering index / Databases / Descending Index / Fulltext Indexes / Hash Index / MariaDB Server / MySQL / MySQL Database / MySQL Server / Percona Server / Spatial Indexes / SQL Index / Unique Index par

 

Introduction

If you’ve been following SimpleTalk for a while, you will be aware that I’ve recently blogged about MySQL indexes. I’ve already told you about the nuances of indexes in MySQL, vanilla B-Tree indexes, composite B-Tree indexes, and other kinds of indexes too.

This blog will walk you through how to choose the perfect index for your specific use case. It will also advise you on the things you should consider to devise the perfect index design in MySQL.

About Indexes in MySQL

One thing you should take away from those blogs is that there are two general types