In this post, I am sharing a script to find missing indexes in MySQL only for those columns which name ended with ‘_id’. The full table scanning is always creating a performance issue for any database. As a Database Professional, you might be adding database indexes on a table but periodically the volume of data […]