Oracle Database - Rows (of Card as Cardinality for 9i)

Card Puncher Data Processing

About

Cardinality is the second measure that Query Plan Estimator use to estimate a execution plan.

It represents the number of rows in a row set that the Optimizer expects to come back.

Here, the row set can be :

  • a base table,
  • a view,
  • or the result of a join or GROUP BY operator.

We can find it in for instance in the Autotrace Output where it represent the estimated number of rows that will flow out of a given execution plan step.

Documentation / Reference





Discover More
Card Puncher Data Processing
Oracle Database - Adaptive Plan

Adaptive plan is an adaptive functionality. The Adaptive plan functionality enables the optimizer to: generate multiple predetermined subplans defer the subplan decision until execution time based...
Card Puncher Data Processing
Oracle Database - Automatic reoptimization / (statistics|cardinality) feedback

Statistics feedback also known as: cardinality feedback Automatic reoptimization is an adaptive feature. It improves plans for repeated queries that have cardinality misestimates. adaptive plans...
Sql Developer Autotrace
Oracle Database - Autotrace

Autotrace is: a system variable of sql plus can also be found in SQL Developer AUTOTRACE provides you: an execution plan (such as explain plan) and some important regarding its actual execution....
Query Optimizer Process
Oracle Database - The Query Plan Estimator

The estimator is involved in the query optimizer process. Its main task is to measure the plans that give the plan generator. It generates three different types of measures : These measures...



Share this page:
Follow us:
Task Runner