If the query is NOT WRITTEN PROPERLY then what are the recommendations you can give to the developer ?
- 1 Answers
- 4379 Views
- Teradata, I also Faced
- E-Mail Answers
Answer / tdguy
In TD, explain plan is like a gift to every developer.
Confidence levels should be observed (low, high or no).
Check for the recommendations of statistics. Try to observe
the plan for any product joins or nested joins. Avoid
unnecessary joins. Use secondary index and join indees
appropriately. Try to repeat the steps in the explain plan
after tuning.
| Is This Answer Correct ? | 7 Yes | 0 No |
What is the purpose of upsert command?
How do you Generate Sequence in Teradata?
What is the difference between fastload and multiload?
What are some primary characteristics of teradata?
What do you mean by teradata intellicloud?
Explain teradata architecture in detail with a diagram.
What are the joins in teradata?
In Teradata, how do we Generate Sequence?
What is the purpose of joins in teradata and what are the available join types?
Why Multiload and Fastload does not supports SI,JI,RI and TRIGGERS?
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
Explain vproc in teradata?
Teradata 
