0 - 2 of 2 tags for #corelated subquery

Currently we have teradata 14 system. I often see a high impact CPU for corelated subqueries. Ex. A query with 4k CPU has ImpactCPU of 10k. My question is how much a coreated subquery efficiently works in teradata. Thanx.

SELECT  oute.*

FROM PDP_TMP.EV_SBSCRP_BTS_USG oute

WHERE  

CASE WHEN oute.PROD_TYPE= EVO

THEN oute.TotalDataCount  =  SELECT  MAX (inne.TotalDataCount)

                                                FROM PDP_TMP.EV_SBSCRP_BTS_USG inne