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
- 34106 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
i learn teradata,it is so intersting,now i want teradata certifications ,so any 1 help me to get teradata certifications TD 12 ? email:kdcrazyy@gmail.com
What are the things to be considered while creating secondary index?
What is bteq script in teradata?
What's the difference between timestamp (0) and timestamp (6)?
In Teradata, how do we Generate Sequence?
Explain teradata architecture in detail with a diagram.
How to eliminate product joins in a teradata sql query?
How to load specific no.of records using bteq, or fastload,or multiload
How to Extract data from multiple legacy systems?
What are aggregate tables? How do you design them using teradata?
What are the available primary index types in teradata.
What are the different design perspectives used in teradata?
What is the meaning of Caching in Teradata?
What is the difference between teradata and oracle?
What is the maximum number of dml can be coded in a multiload script?
