Sql Engine - Relational Operator (Data operations|Execution Plan Steps)

About

Relational operator

They are the step of a plan (execution parse tree).

List

• read (SQL Engine - (Access|Scan) (Paths|Method))
• 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