- **Description**: Stores intermediate results in memory for reuse. - **Performance**: Stores intermediate results, potentially costly. - **Factors**: Size of intermediate results, memory costs. - **Cost**: `materialization cost + cpu_tuple_cost * number of tuples` - ![[ex_materialize.svg|200x200]] - **Operates on**: [[Result Set]] - **Workloads**: - [[IO]] - [[BufFileRead]] - [[BufFileWrite]] - [[LWLock]] - [[BufferContent]]