SQL Engine - (Set|Set-based) Operation

Oracle Database Sql Processing

About

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 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...
Card Puncher Data Processing
Oracle Database - MERGE JOIN operation

MERGE JOIN joins tables by merging sorted lists of records from each tableon the join column. It is effective for large batch operations, but may be ineffective for joins used by transaction-processing...
Oracle Database Star Transformation
Oracle Database - Star Transformation

This article talk the application of the star query in Oracle which involve a star schema. Star transformation executes the query in two phases: retrieves the necessary rows from the fact table (row...
Data System Architecture
Relation - Bitmap Indexes

Normally in a btree, there is a one-to-one relationship between an index entry and a row: an entry points to a row. Indexes should be selective in general. With Bitmap Indexes, a single entry uses a bitmap...
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