If the query is NOT WRITTEN PROPERLY then what are the recommendations you can give to the developer ?
- 1 Answers
- 4233 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
What are the string manipulation operators and functions associated with teradata?
How do you do backup and recovery in teradata?
Describe the between keyword in teradata?
List out some of the primary characteristics of teradata.
Give the sizes of SMALLINT, BYTEINT and INTEGER.
If the PMON is not working then how do you identify and monitor all the processes, resources and sessions ?
What are the advantages of teradata?
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 are normalization, first normal form, second normal form and third normal form?
What are the different methods ot loading a dimension table? A fact table etc?
List out teradata data types?
Difference between multiload and tpump?
If Fast Load Script fails and only the error tables are made available to you, then how will you restart?
What are the primary characteristics of the Teradata.
What exactly do you know about catching in teradata?
