Sql Engine - Query Plan (Step|Operation)

Oracle Database Sql Processing

About

A query plan step is essentially an relational operator with its arguments.

Goal

A operation may be:





Discover More
Oracle Database Sql Processing
SQL Engine - (Set|Set-based) Operation

An Operation that implements a mathematics set function. A set operation does not return records to the next operation until all of the rows have been processed in contrast to row operation, returning...
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...
Oracle Database Sql Processing
Sql Engine - Row Operation

A row operation returns the first records to the next operation quickly. NESTED LOOPS



Share this page:
Follow us:
Task Runner