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?
SELECT A.test, B.test FROM A INNER JOIN B ON A.NUM_COL = B.CHAR_COL
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.