Hi,

I've currently got a sizeable MySQL database (using MyISAM tables)
where one table holds about 5 million entries, and SELECT queries are
really starting to slow down.

It seems that it would probably be more beneficial to split this down
into a few hundred tables and access the data via a MERGE table.

I can easily write a PHP script to recursively create the new tables
and move the relevant data accross to the new tables, then I can
create the new MERGE table.

My query is that because the current table is indexed, when I split
the existing table out into smaller tables, should I re-index each
table before I create the MERGE table ?

Thanks
Neil.