What EXPLAIN does in Teradata, what is High confidence, Low
confidence and No confidence.. And How we improve the query
performance .
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 PDE.
How do you set the session mode parameters in bteq?
What do you mean by teradata intelliflex?
How to eliminate product joins in a teradata sql query?
Explain the most common data types used in teradata?
What do you mean by ttu in teradata?
If I wanted to run a TPump job only once per day - basically working on a file that is produced once per day - how would you set up the parameters for that sort of job ?
What is a node in teradata?
What is basic teradata query language?
What is oltp?
What can be achieved by using the teradata rdbms?
Highlight the limitations of TPUMP Utility.
Explain the term 'row' related to relational database management system?
How to write the query . eid enm doj dob i want to display the names who worked more than 25 years .
What do you mean by teradata sql assistant?