Depends if materialization helps. As a silly example, if the CTE materializes 1/100th of a table via table scan, scanning 1/100th of a table N times may be fas

Depends if materialization helps. As a silly example, if the CTE materializes 1/100th of a table via table scan, scanning 1/100th of a table N times may be faster than scanning the entire table N times.