Finds queries whose WHERE, JOIN and ORDER BY columns have no matching index, so the database scans a whole table as it grows. Returns each slow query, the index that serves it with the column order, the write cost it adds, and an EXPLAIN check to run before and after.