All Forums General
Pentium4 1 post Joined 12/12
08 Dec 2014
varchar join integer

Consider two tables ,one has COLUMN_A defined as a VARCHAR(100) and the other has COLUMN_A defined as an INTEGER. When joining these two tables via COLUMN_A what does the optimizer have to do in order to accomplish the join?Convert VARCHAR to INTEGER  or convert INTEGER to VARCHAR? thanks.

dnoeth 4628 posts Joined 11/04
09 Dec 2014

When you look at Explain you will see that the VARCHAR is casted to a FLOAT.

Dieter

You must sign in to leave a comment.