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
What is stored procedure in teradata?
What is a sparse index?
What are the different functions included in the server software?
How many types of joins are there in teradata?
Difference between stored procedure and macro?
What does Amp contain and what are all the operations that it performs?
What do you mean by teradata intellicloud?
In a table can we use primary key in one column and in another column both unique and not null constrains.if yes how?
How you will check the version of teradata?
Explain teradata utilities. What is multiload, fast load, tpump?
Why does varchar occupy 2 extra bytes?
If a Node is busy what are the steps you can take to avoid ?
What are different table types used in teradata?
What is called partitioned primary index (ppi) and discuss the advantages of using it in a query?
Why are oltp database designs not generally a good idea for a data warehouse?