Sql Engine - Row Operation

Oracle Database Sql Processing


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

Discover More
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...
Relational Algebra Between Sql And Query Plan
Relation Operator - Nested Loop Join

Nested loop joins are join operator. They are useful when small subsets of data are being joined and if the join condition is an efficient way of accessing the second table. NESTED LOOPS is a row operation....
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 Processing
Sql Engine - Query Plan (Step|Operation)

A query plan step is essentially an relational operator with its arguments. A operation may be: a row operation a set operation or both

Share this page:
Follow us:
Task Runner