If the query is NOT WRITTEN PROPERLY then what are the recommendations you can give to the developer ?
- 1 Answers
- 4378 Views
- Teradata, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
Explain Teradata performance tuning and optimization?
What is teradata? What are some primary characteristics of teradata?
Hi, If anyone has TD 14 Basics dumps or study materials, please share. nirmaaal1991@gmail.com
What is meant by a Least Cost Plan?
What are the commands to make a new table, change a table and remove a table in teradata?
What are the available join types in teradata?
What happens when a node suffers a downfall?
If the PMON is not working then how do you identify and monitor all the processes, resources and sessions ?
Which is more efficient group by or distinct to find duplicates?
In Teradata, how do we Generate Sequence?
What is the meaning of Caching in Teradata?
Is it necessary to add? Quit statement after a bteq query when I am calling it in a unix environment?
How is the teradata different from oracle?
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 the teradata primary index mechanics in detail with a diagram.
