Eli wrote:
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
How would an index on columns in two different tables help you with a join
of those two tables? Perhaps if you told us what you are really trying to
do, someone could suggest a solution.
Michael
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]