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
- 34259 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
What are some primary characteristics of teradata?
What is meant by a Parsing Engine?
What are the available primary index types?
Explain the term 'columns' related to relational database management system?
List out all forms of LOCKS that are available in Teradata.
Backup Script was blocked you are unable to archive the data now. how do you analyze it and where do you identify ?
How many sessions of MAX is PE capable of handling at a particular time?
What are types of partition primary index (ppi) in teradata?
List the logical and conditional operators that are used with teradata along with their meanings?
What are the things to be considered while creating secondary index?
What is meant by a Least Cost Plan?
Differentiate database data and data warehouse data?
What are the available join types in teradata?
What are normalization, first normal form, second normal form and third normal form?
What are the various indexes in teradata? How to use them?
