Interested to Buy Any Domain ? << Click Here >> for more details...
What EXPLAIN does in Teradata, what is High confidence, Low
confidence and No confidence.. And How we improve the query
performance .
- 5 Answers
- 34277 Views
- Accenture, I also Faced
- E-Mail Answers
Answer Posted / yuvaevergreen
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 indicate how well the optimizer is
aware about the demographic data for a particular step.
>>High confidence: Means the optimizer know about the no of
rows that would be returned as a result of that step.
Examples would be when PI statistics exist when the column
or range stats exist or no join involved.
>>Low confidence: Some stats available. Join and stats
available on both sides of the join.
>>No confidence: No stats available. Join involved.
| Is This Answer Correct ? | 8 Yes | 1 No |
Post New Answer View All Answers
What are the advantages of teradata?
What is the opening step in basic teradata query script?
Mention a few of the ETL tools that come under Teradata.
What are the different table types that are supported by teradata?
How does hashing happens in teradata?
How many sessions of MAX is PE capable of handling at a particular time?
How to Extract data from multiple legacy systems?
Explain the new features of teradata?
How can bottlenecks be identified?
What are the scenarios in which full table scans occurs?
If RDBMS is halted what will you do ?
What do you mean by teradata sql assistant?
How many codd's rules are satisfied by teradata database?
What are the different functions performed in development phase?
How do you define Teradata?
