Does implicit conversion in a join in Teradata SQL have any impact on spool space, or is it only going to impact speed, or nothing?

Is there any performance difference between these two options below?

Option 1

SELECT A.test, B.test
FROM A
    INNER JOIN B
    ON A.NUM_COL = B.CHAR_COL

Option 2

SELECT A.test, B.test
FROM A
    INNER JOIN B
    ON A.NUM_COL = CAST(B.CHAR_COL AS INTEGER)

It seems there isn't much impact from my own experimentation, but wanted to confirm. I've Googled around and can't find much. Thanks.

0 Answers