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
- 5114 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 is upsert statement in teradata?
What is bteq utility in teradata?
What is basic teradata query language?
If RDBMS is halted what will you do ?
Can you connect multiload from ab initio?
What is the primary index in teradata?
Did you write stored procedures in teradata?
Difference between inner join and outer join?
Highlight the points of differences between the database and user in Teradata.
Explain teradata utilities?
How to load specific no.of records using bteq, or fastload,or multiload
Comment whether bottleneck is an error or not.
What is a three-tier data warehouse?
What is smp and mpp platforms?
What is the purpose of joins in teradata?
