Difference in Estrowcount and Actrowcount.

Database
Teradata Employee

Difference in Estrowcount and Actrowcount.

Hi , Can anyone help me to understand why there is difference in Estrowcount and Actrowcount even if i have absolutely collected stats. Thanks in Advance. Best Regards, Sunder
1 REPLY
Teradata Employee

Re: Difference in Estrowcount and Actrowcount.

Estimated Row Count is calculated by the optimizer when building the execution plan and is based on what it knows about the data statistics. It is affected by the probability of the matching conditions in the predicate of the query.