--disable_warnings

DROP DATABASE IF EXISTS db;

--enable_warnings

CREATE DATABASE db;

USE db;

--let $tables = 200

while ($tables) 

{

	--let $sql = CREATE TABLE t$tables (pk INT NOT NULL

	--let $indexes = PRIMARY KEY (pk)

	--let $columns = 63

	while ($columns) 

	{

		--let $sql = $sql, c$columns INT

		--let $indexes = $indexes, INDEX ind$columns (c$columns)

		--dec $columns

	}

	--let $sql = $sql, $indexes) ENGINE=MyISAM

	--eval $sql

	--dec $tables

}

SET SESSION group_concat_max_len=100*1024*1024;

SELECT GROUP_CONCAT(CONCAT('SELECT COUNT(`',column_name,'`) FROM `',table_schema,'`.`',table_name,'` FORCE INDEX (`',index_name,'`)') SEPARATOR ' UNION ALL ') INTO @sql FROM information_schema.statistics WHERE table_schema NOT IN ('information_schema','mysql') AND seq_in_index = 1;

select length(@sql);

prepare stmt from @sql;

DROP DATABASE db;

insert into...

select from (

  select [constants]

  union all

  select [constants]

  union all

 ...

) left join ...

where ...