Concat('A', 'B') vs 'A' || 'B' in Teradata
Noticed, That There Are Two Ways to Concatenate Strings in Teradata. Concat('A', 'B') 'A' || 'B' as Every Second Counts, Which One Is Faster? Select...
Noticed, that there are two ways to concatenate strings in Teradata.
CONCAT('a', 'b')'a' || 'b'
As every second counts, which one is faster?
SELECT CONCAT('a', 'b'), 'a'||'b';
or these are compiled to the same operation?
1 Answer
Both are completely interchangeable and none gives any performance boost.
Alexander Ross has covered the video game industry for a decade, writing deep dives on game design, esports tournaments, VR developments, and gaming culture.
