### SetOp - **Description**: Performs set operations like UNION, INTERSECT, EXCEPT. - **Performance**: Depends on set operation (UNION, INTERSECT, EXCEPT). - **Factors**: Size of input datasets, operation type. - **Cost**: `set operation cost * number of rows` ![[assets/ex_setop.svg|256]] ![[assets/ex_hash_setop_except_all.svg|256]] - **Operates on**: [[Structures/Result Set]] - **Workloads**: - [[Workloads/IO]] - [[Workloads/Sub/BufFileRead]] - [[Workloads/Sub/BufFileWrite]] - [[Workloads/LWLock]] - [[Workloads/Sub/BufferContent]]