Interested to Buy Any Domain ? << Click Here >> for more details...
What EXPLAIN does in Teradata, what is High confidence, Low
confidence and No confidence.. And How we improve the query
performance .
- 5 Answers
- 34008 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
Syntax for case when statement?
What is spool space and when running a job if it reaches the maximum spool space how you solve the problem?
What is meant by a Parsing Engine?
How to eliminate product joins in a teradata sql query?
Describe the set operators in teradata.
Name the five phases that come under MultiLoad Utility.
Briefly explain each of the following terms related to relational database management system (rdbms) – database, tables, columns, row, primary key and foreign key.
Explain the new features of teradata?
Hi, If anyone has TD 14 Basics dumps or study materials, please share. nirmaaal1991@gmail.com
Define views in teradata with syntax.
If the PMON is not working then how do you manage and monitor all processes, resources and sessions etc.
How would you load a very large file in teradata in general? What utility would you use for it? Why?
Explain the term 'foreign key' related to relational database management system?
In Teradata, what is the significance of UPSERT command?
Write a program to show the parser component used in teradata?
