Improving Row Estimates with Teradata Check Constraints
Without Teradata CHECK Constraint When a non-indexed column is utilized in a retrieval operation (i.e. WHERE statement) and lacks Teradata Check Constraints, the Optimizer employs heuristics to approximate the number of rows in the resulting set by inferring missing statistics. The estimated number of rows is 7,342, equivalent to 10% of the table’s total rows. …