What EXPLAIN does in Teradata, what is High confidence, Low
confidence and No confidence.. And How we improve the query
performance .
Answer Posted / yuvaevergreen
1.Explain helps us to know about the stats needed.
| Is This Answer Correct ? | 3 Yes | 6 No |
Post New Answer View All Answers
Why managing the data is important?
What is the difference between teradata and oracle?
What are some commonly used bteq scripts?
What is a clique?
What do you mean by ttu in teradata?
Describe primary index in teradata. And what are the available primary index types?
Explain PDE.
What are the uses of bynets in multi-node systems?
Define views in teradata with syntax.
What is meant by a node?
Let us say there is a file that consists of 100 records out of which we need to skip the first and the last 20 records. What will the code snippet?
What are the steps involved in the process flow of the sql statement through channel attached system?
What are default access rights in teradata?
A certain load is being imposed on the table and that too, every hour. The traffic in the morning is relatively low, and that of the night is very high. As per this situation, which is the most advisable utility and how is that utility supposed to be loaded?
What are the different softwares used with their functions in teradata?