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
What is the particular designated level at which a LOCK is liable to be applied in Teradata?
Syntax for case when statement?
Highlight the points of differences between the database and user in Teradata.
What are the main components of teradata system?
Difference between star and snowflake schemas?
What are the 5 phases in a multiload utility?
What is the use of virtual processor connectivity in teradata?
How to load specific no.of records using bteq, or fastload,or multiload
What is the difference between teradata and basic rdbms?
What is the use of fallback?
Highlight the limitations of TPUMP Utility.
What are some commonly used bteq scripts?
Highlight the differences between Primary Key and Primary Index.
How is MLOAD Client System restarted after execution?
Explain the teradata primary index mechanics in detail with a diagram.