Gleb Paharenko wrote:
You may want to think about the MERGE storage ENGINE, however it doesn't have a real spanned index. See: http://dev.mysql.com/doc/mysql/en/merge-storage-engine.html
MERGE is not the case here, since it is JOIN of tables which are different in defintion. MERGE table would be helpful if UNION on same-defined tables was used..
It seems that the solution for this (as for now) is to combine all the tables into one big table and index fields over it.
-thanks, Eli -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
