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
- 34285 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 the available primary index types in teradata.
How do you determine the number of sessions?
What is meant by a Channel Driver?
Why do you get spool space errors? How do trouble-shoot them?
What is the multi-insert?
What are the uses of client software involved in teradata?
What is upsert statement in teradata?
How do you set the session mode parameters in bteq?
What is smp and mpp platforms?
What do high confidence, low confidence and no confidence mean in explain plan?
What is the use of stored procedures in teradata?
What is spool space? Why do you get spool space errors?
What is node? How many nodes and amps used in your previous project?
How to load specific no.of records using bteq, or fastload,or multiload
What are the components provided on node?
