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

> (Data|State) Management and Processing > (Data Type|Data Structure) > (Relation|Table) - Tabular data > RDBMS - Sql Processing (Engine)

Table of Contents

1 - About

Relational operator

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

List

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
Advertising