Re: JOIN columns with different types

[Victor Pendleton]

A data type conversion will have to take place and depending on the size 
of the tables the performance could be quite miserable.

Qunfeng wrote:
Hi,
MySQL seems to be able to JOIN columns with different types, e.g., one 
column type is int; the other type is varchar.  My question is: how 
badly does that affect the join performance even though both columns are 
indexed.

Thanks!
Qunfeng


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]