What EXPLAIN does in Teradata, what is High confidence, Low
confidence and No confidence.. And How we improve the query
performance .
- 5 Answers
- 32055 Views
- Accenture, I also Faced
- E-Mail Answers
Answer Posted / farooq
explain provides execution procedure(stratergy).It gives
the estimated time,confidence and memory needed to execute
the query.It is used to analayze all joins and complex
queries.
"EXPLAIN parses the sql atatement but does not execute it".
| Is This Answer Correct ? | 24 Yes | 1 No |
Post New Answer View All Answers
Explain the new features of teradata?
What are the different design perspectives used in teradata?
What are the different softwares used with their functions in teradata?
What tools would you use for that?
What do you mean by teradata intellicloud?
What is TPD?
What is a three-tier data warehouse?
Backup Script was blocked then you are unable to archive the data. how do you analyze it and where do you identify ?
How does hashing happens in teradata?
What is the purpose of indexes?
Write a program to show the parser component used in teradata?
Explain some differences between mpp and smp?
What is meant by a dispatcher?
How can we check the version of Teradata that we are using currently?
How to load specific no.of records using bteq, or fastload,or multiload
