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
- 34474 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
Why do you get spool space errors? How do trouble-shoot them?
Explain teradata vs. Redshift?
What do high confidence, low confidence and no confidence mean in explain plan?
How can you track login parameters of users in teradata?
List out teradata data types?
What do you mean by teradata intellicloud?
Can any one explain me the difference between BTEQ and MLOAD,TUMP. All canbe used for same purpose but still differnt methods. why ?
Can you connect multiload from ab initio?
Explain some differences between mpp and smp?
What is the use of virtual processor connectivity in teradata?
Explain how spool space is used.
What are the available primary index types in teradata.
Explain the meaning of Amp?
What is spool space? Why do you get spool space errors?
Briefly explain each of the following terms related to relational database management system (rdbms) – database, tables, columns, row, primary key and foreign key.
