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
- 6771 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
How does hashing happens in teradata?
How many tables can you join in v2r5?
What are the multiload utility limitations?
What is partitioned primary index (ppi)?
What's the difference between timestamp (0) and timestamp (6)?
if collect stats but it show low confidence why?
How do you create tables? Exact syntax, and create profiles, users in teradata?
What is the basic syntax for teradata select statement?
How to load specific no.of records using bteq, or fastload,or multiload
What is a three-tier data warehouse?
What is the primary index in teradata?
Why does varchar occupy 2 extra bytes?
In BTEQ, how are the session-mode parameters being set?
List out all forms of LOCKS that are available in Teradata.
What is spool space and when running a job if it reaches the maximum spool space how you solve the problem?
