DB2 stores intermediate results. Deep hierarchies with wide rows consume TEMP space. 2. **No indexes on intermediate results** — the join in the recursive member scans the previous iteration's output. Keep the CTE columns narrow. 3. **UNION ALL is mandatory** — UNION (with duplicate elimination) is