Interested to Buy Any Domain ? << Click Here >> for more details...
how to improve the query perfoemance in teradata.with example?and how explain this in interview?please forward answer
- 2 Answers
- 6652 Views
- IBM, I also Faced
- E-Mail Answers
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 a dimension table?
Can you connect multiload from ab initio?
What are the frequently used data types in teradata?
Backup Script was blocked then you are unable to archive the data. how do you analyze it and where do you identify ?
Discuss the advantages of using partitioned primary index in a query?
What is dimensional modeling?
What are the different methods ot loading a dimension table? A fact table etc?
if collect stats but it show low confidence why?
What are the functions of a teradata dba?
How do you verify a complicated sql?
What is called partitioned primary index (ppi)?
Highlight the need for Performance Tuning.
What is TPD?
Explain teradata architecture in detail with a diagram.
What is the maximum number of dml can be coded in a multiload script?
