RIGHT_CARDINALITY (JOIN Option)
RIGHT_CARDINALITY provides a cardinality hint for the right-hand side (RHS) of a join. The optimizer uses this option’s value as a hint to help choose a better query execution plan.
If RIGHT_CARDINALITY is not specified, the optimizer relies on statistics processing for cardinality estimates.
Operator
JOIN
Syntax
RIGHT_CARDINALITY=<int>
The <int> argument specifies the cardinality value to use for the right-hand side.
Example
SELECT column1 FROM table1 INNER {OPTION RIGHT_CARDINALITY=10000}
JOIN table2 ON table1.id = table2.id