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
- 4996 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
How is MLOAD Client System restarted after execution?
Can we collect statistics on multiple columns?
What do you mean by tpt in teradata?
What are the frequently used data types in teradata?
What is basic teradata query language?
Explain the types of join supports by teradata?
Is it necessary to add? Quit statement after a bteq query when I am calling it in a unix environment?
Explain and compare pros and cons of start schemas?
Highlight the differences between Primary Key and Primary Index.
Different phases of multiload?
Steps to create a data model?
Describe the set operators in teradata.
What does sleep function does in fast load?
What type of indexing mechanism do we need to use for a typical data warehouse?
What is a clique?
