About
They are the step of a plan (execution parse tree).
List
- filter,
- sort,
- join
- aggregation
- ….
Type of operation using the work area:
- SORT,
- HASH JOIN,
- GROUP BY,
- BUFFERING,
- BITMAP MERGE,
- or BITMAP CREATE
Others:
- out of core operations are made with the help of the disk
- in of core operations are made within memory