MS SQL INNER JOIN is taking very long time [closed]

Question

The below part of the CTE runs very very slow. When I look at the execution plan 78% of its cost goes to Nested Loops (Inner Join)

Are there any issue w.r.t performance in this query ? Below is JOIN that is consuming the memory

SELECT  
    D_HQ.Hour_Quarter_ID,  
    c_AP.PrevEvent,  
    c_AP.PrevEventTime,  
    c_AP.Event,  
    c_AP.Operator_ID,  
    c_AP.Zone_ID,  
    c_AP.Load_Unit_Id  
FROM  
    cte_Apply c_AP  
JOIN OA.DIM_Hour_Quarter D_HQ   
    ON c_AP.PrevEventTime >= D_HQ.Hour_Quarter_Start_Time  
    AND c_AP.PrevEventTime < D_HQ.Hour_Quarter_End_Time   
OPTION (MAXRECURSION 0)  

Part of the Execution Plan