0 - 2 of 2 tags for concatenation -performance issue..

Teradata Data Stream Architecture (DSA) is a new product offering for Teradata Backup and Restore, providing significant performance and usability improvements over existing backup and restore functionality.

Hi all,
The below query is taking 3 minutes to produce the result...The concatenation in the INNER JOIN condition is taking a long time and B0500 table is having 200 GB of data.. and S045021 is having 1gb of data inside..

SELECT

B0500.EDW_KEY As Event_Id

,S045021.M_NB_TRN||'_'||S045021.M_NB||'_'||S045021.M_REPDATE||'_'||S045021.M_ACCOUNT As Transaction_Id

FROM

DP_SEDW.S045041_MX_LBV_ACJD_REP AS S045021

INNER JOIN DP_TEDW.T0500_KEY_EVENT B0500