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
- 5058 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 the difference between union and union all in teradata?
What is meant by a Parsing Engine?
What is a node in teradata? Explain
What are the commands to make a new table, change a table and remove a table in teradata?
What are the different methods ot loading a dimension table? A fact table etc?
What are default access rights in teradata? What explicit right can be given to a user?
Mention a few of the ETL tools that come under Teradata.
Difference between stored procedure and macro?
How would you load a very large file in teradata in general? What utility would you use for it? Why?
Different phases of multiload?
How do you set the session mode parameters in bteq?
Backup Script was blocked then you are unable to archive the data. how do you analyze it and where do you identify ?
Where is teradata rdbms used?
What is the function of parser component in teradata?
How many types of joins are there in teradata?
