What EXPLAIN does in Teradata, what is High confidence, Low
confidence and No confidence.. And How we improve the query
performance .
- 5 Answers
- 31969 Views
- Accenture, I also Faced
- E-Mail Answers
Answer Posted / farooq
HIGH CONFIDENCE:Statistics are collected up to date.
LOW CONFIDENCE:Statistics are not up todate.
NO CONFIDENCE:Statistics are not collected.
| Is This Answer Correct ? | 16 Yes | 2 No |
Post New Answer View All Answers
Explain teradata vs. Redshift?
Difference between stored procedure and macro?
Explain the types of join supports by teradata?
Describe primary index in teradata?
What are the main components of teradata system?
What is collect statistics?
How would you load a very large file in teradata in general?
Hi, If anyone has TD 14 Basics dumps or study materials, please share. nirmaaal1991@gmail.com
What are differences between teradata and ansi session modes in teradata?
what is object level locking ? where do appear this type of locking ?
What are the primary characteristics of the Teradata.
What are the functions of a teradata dba?
What are the enhanced features in teradata v2r5 and v2r6?
In general, how do you optimze any sql in teradata?
What are the various indexes in teradata?
