Hi Manuel,
Manuel Vacelet wrote:
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.
This doesn't seem to make sense if this is not a very rare corner-case.
Either both columns should be INT or VARCHAR.
BTW, how can I get the number of rows examined (like in slow queries
log) from mysql command line ?
Run: EXPLAIN [query]
have a look at the "rows" column there.
regards
Nils
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
