I have a query where teradata expain is giving wrong esitmated time though the query is taking very few seconds.
It is estimating 9 mins due to which it is getting throttled. Issue is in step 7. All the stats are ok and refreshed.
Could anyone pleae suggest what might be wrong.
The time it takes for a query to execute has nothing to do with the labels used in teh explain plan.
There is absolutey no correlation between the labels on the cost values in an explain plan and clock time. The words "days", "hours", "minutes" and "seconds" are all pronounced the same way when evaluating an explain plan, kost.
Would you please post the table DDL and query, if you are able?