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
- 34254 Views
- Accenture, I also Faced
- E-Mail Answers
Answer Posted / adi
explain gives the execution strategy means what are the
different steps that the query will go through.
HIGH CONFIDENCE:Statistics are collected.
LOW CONFIDENCE:Statistics are not collected. But the where
condition is having the condition on indexed column. Then
estimations can be based on sampling.
NO CONFIDENCE:Statistics are not collected and the
condition is on non indexec column.
| Is This Answer Correct ? | 18 Yes | 3 No |
Post New Answer View All Answers
What are default access rights in teradata?
What are some primary characteristics of teradata?
Explain the new features of teradata?
Hi Friends, Please send me Teradata Materials for certifications Thanks in advance !!
Explain the term 'database' related to relational database management system?
How you will check the version of teradata?
What is the syntax for case when statement?
In general, how do you optimze any sql in teradata?
What is teradata? Also, list out some of the primary characteristics of teradata.
Explain the meaning of Amp?
Differentiate primary key and partition key?
Highlight all the modes that are present under Confidence Level.
What is collect statistics?
What is meant by a node?
How would you load a very large file in teradata in general? What utility would you use for it? Why?
