Pipelining reduces the need for large temporary storage but is not always usable (e.g. for sort, hash join)

Pipelining is always usable for all relational operators

Materialization always yields lower total I/O cost than pipelining

Materialization allows no reuse of intermediate results