Hi all, I have query that joins 2 tables. I have an index on each part of the join but unfortunately the 2 columns don't have the same type so the index is not used for the join (I guess it's the reason why). On one hand I have an INT and on the other and a VARCHAR.
Is there any way to write the query to use indexes or do I have to change my schema ? I'm using Mysql 4.1 with MyIsam engine. BTW, how can I get the number of rows examined (like in slow queries log) from mysql command line ? Thanks, Manuel -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
