- **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` - ![[assets/ex_materialize.png|200x200]] - **Operates on**: [[Structures/Result Set]] - **Workloads**: - [[Workloads/IO]] - [[Workloads/Sub/BufFileRead]] - [[Workloads/Sub/BufFileWrite]] - [[Workloads/LWLock]] - [[Workloads/Sub/BufferContent]]