Indexing

Articles
MySQL

Unused Indexes in MySQL: A Basic Guide

Indexes are frequent friends for SELECT queries; however, if we want to use indexes, we must ensure that our database instances use them first. Indexes that are not utilized by our database instances are useless – they waste space and make INSERT, UPDATE, and DELETE queries slower.

By Lukas Vileikis
a month ago

MySQL Indexing Best Practices

During my work tenure, I got a chance to work with MySQL databases with as many as 700 million rows. This post will emphasize how to index and optimize your MySQL queries for indexes.

By Akhil Mathew
3 months ago
Arctype

MySQL Schema Design: Back to The Future?

Once developers find themselves in the MySQL world, they will almost certainly hear some advice on how they should go about designing database schemas in MySQL. This blog post will provide insight into what you should consider when dealing with database schemas in MySQL.

By Lukas Vileikis
4 months ago