Sql Engine - Plan

Oracle Database Sql Processing


When a request is invoked, the optimizer optimizes the logical plan and generates a physical plan for efficient execution.


Discover More
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 - Relational Operator (Data operations|Execution Plan Steps)

Relational operator They are the step of a plan (execution parse tree). List read () filter, sort, join aggregation .... Type of operation using the work area: SORT, HASH JOIN,...

Share this page:
Follow us:
Task Runner