The explain generally displays the plan which would be prepared by Optimizer. We can say that(though not accurate), plan would be the steps followed by Teradata to solve a query. Confidence levels ind...
Low Confidence: Normally when stats are difficult to use preciselyHigh Confidence: Normally Optimizer is sure of the results based on the stats available