Interested to Buy Any Domain ? << Click Here >> for more details...
If the query is NOT WRITTEN PROPERLY then what are the recommendations you can give to the developer ?
- 1 Answers
- 4974 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 |
How is the teradata different from oracle?
What is Difference b/w PI & PPI?how to implement PPI?
Different phases of multiload?
What is the difference between teradata and oracle?
What do you mean by teradata intelliflex?
How can bottlenecks be identified?
what are the day to day activities of teradata DBA ?
What is meant by Teradata Gateway?
how can we analyze the locks ?
What are the available primary index types in teradata.
Syntax for case when statement?
Difference between Teradata V2R5 and Teradata V12 versions?
Teradata 
