MySQL: Script to find Missing Indexes for particular type of Columns

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 […]

July 4, 2017 MySQL, MySQL DBA Script