If you’ve been following Simple Talk for a while, you know that we’re fans of databases and everything they involve. We’re also big fans of database performance, too. And if you’re a developer or a DBA, you surely know one of the primary answers to database performance – indexing! We’ve already told you about indexes when we talked about multiple approaches to improve your query performance and we’ve already told you about indexing nuances during some of our previous blog posts, too.
We’ve also walked you through the default – B-Tree – type of indexes in MySQL. Now it’s