Bruteforce. Index all the columns in all tables of a db.

MySql - Index all columns

-- Bruteforce. Index all the columns in all tables of a db.

-- Find the data types
-- select distinct data_type from information_schema.columns where table_schema="DATABASE";

select
concat( "ALTER TABLE  `DATABASE`.`", table_name ,  "` ADD INDEX (  `",column_name  ,"` );"   )
from information_schema.columns where table_schema='DATABASE' and
data_type not in ('text', 'longtext', 'mediumtext','tinytext' );