how to improve the query perfoemance in teradata.with example?and how explain this in interview?please forward answer
Answer Posted / tdguy
Performance tuning increases with experience. Some tips
are: Analyze the plan displayed by TD. This would give
enough information about the query, data and performance.
Check for confidence levels. Try to identify the type of
joins. Avoid product, cartesian product and nested joins.
1. try to avoid unnecessary joins 2. Try to join using
unique value columns 3. collect stats 4. Use secondary
index appropriately 5. Use join index, if necessary 6.
Split the query, if necessary.
Again, see the plan and repeat the steps.
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
Describe primary index in teradata?
What are the various indexes in teradata? Why are they preferred?
What is the command in bteq to check for session settings ?
Which is more efficient group by or distinct to find duplicates?
What do you mean by tpt in teradata?
What is the use of virtual processor connectivity in teradata?
tomorrow i have interview in infosys.can someone pour any suggestions or any interview questions. thank you
What do you mean by teradata intellicloud?
Why are oltp database designs not generally a good idea for a data warehouse?
If RDBMS is halted what will you do ?
Explain and compare pros and cons of snow flake schemas?
What are the functions of a teradata dba?
Explain the term 'columns' related to relational database management system?
How many types of joins are there in teradata?
Explain fastload in teradata?