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

Oracle Database Sql Processing

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





Discover More
Card Puncher Data Processing
Oracle Database - (Query) Work Area

The work area is an memory area that is used to perform data operation such as: SORT see sort area memory, HASH JOIN see hash area memory, GROUP BY, BUFFERING, BITMAP MERGE, or BITMAP CREATE...
Oracle Database Hash Redistribution
Oracle Database - Data Redistribution (Parallel)

Data redistribution is not unique to the Oracle Database. In fact, this is one of the most fundamental principles of parallel processing, being used by every product that provides parallel capabilities....
Card Puncher Data Processing
Oracle Database - Join (Operation|Method|Mechanism|Algorithm)

Joins are data operation / method / algorithm in order to match data from more than one table. They all require sorting and then matching aspects of a dataset. There are only three join mechanisms used...
Card Puncher Data Processing
Oracle Database - Sort Aggregate Operation

Operation used to calculate an aggregate function such as an avg.
Relational Algebra Between Sql And Query Plan
Relational Algebra - Expression and Operators

Relational algebra is based upon the fact that you can pass tabular data through a set of data operators (select, filter, join, sort, union, etc.) in a algebraic structure. It means that: the output...
Oracle Database Sql Processing
SQL Engine - (Access|Scan) (Paths|Method)

Access paths are relational operator (ways, techniques) that retrieves data from the database. scan In general, index access paths should be used for statements that retrieve a small subset of table...
Oracle Database Sql Execution Parse Tree
SQL Engine - How to read a physical plan (Execution Plan | Execution Tree)

How to read a physical plan The figure below is an execution tree or physical plan, that shows the flow of row sources from one step to another. In general, the order of the steps (relational operator)...
Oracle Database Sql Execution Parse Tree
SQL Engine - How to read a query plan ?

How to read a query plan (ie a execution tree) ? Each row in the output table corresponds to a single step in the execution plan. The first step is the furthest indented to the right. As it's...
Rewrite
SQL Engine - Query Rewrite

query rewrite is a query performance technique enabled by the query transformer that rewrites the original query to use materialized view instead. As the materialized view (a view stored in a table fashion)...
Oracle Database Sql Processing
SQL Engine - Row source generator

The row source generator performs the row source generation steps of an SQL processing. It receives the optimal execution plan from the optimizer and produces an iterative plan, called the query plan,...



Share this page:
Follow us:
Task Runner