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
- 34473 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
Different phases of multiload?
In general, how do you optimze any sql in teradata?
How can you track login parameters of users in teradata?
What happens when a node suffers a downfall?
what are the uses of fact table and dimension table in banking project?
any one answer me how they can analyzing the project using data ware housing?
During the Display time, how is the sequence generated by Teradata?
What are teradata utilities?
hi frnds i want to learn teradata utilities and teradata dba real time. i have 1+ years of experience in teradata. so i want to go deeply in Tearada. plz let me know at my email id who r best to learn from. im lookng for a realtime guy in HYD or Banglr. Thanks in advance. Rajesh my email-id: rajeshmss87@gmail.com
What is spool space and when running a job if it reaches the maximum spool space how you solve the problem?
What is teradata?
What are default access rights in teradata? What explicit right can be given to a user?
What is the use of stored procedures in teradata?
What is upsert statement in teradata?
What are the uses of client software involved in teradata?
