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
- 34096 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 is the purpose of upsert command?
List out some of the primary characteristics of teradata.
What are the various reporting tools in the market?
How to eliminate product joins in a teradata sql query?
What are the functions of a Parser?
What do you mean by parsing?
Explain the term 'primary key' related to relational database management system?
Explain the term 'database' related to relational database management system?
Explain the teradata primary index mechanics in detail with a diagram.
What are types of partition primary index (ppi) in teradata?
What is partitioned primary index (ppi)?
What is difference between user and database in teradata?
What is called partitioned primary index (ppi) and discuss the advantages of using it in a query?
What is the difference between union and union all in teradata?
What are the different table types supported by teradata?
