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
- 6770 Views
- IBM, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / gowthami
hIIIIIII.........
BY using indexes and collect statistics we can increase the
query performance
| Is This Answer Correct ? | 1 Yes | 0 No |
Why teradata is used?
if collect stats but it show low confidence why?
In the Primary Index, what is the score of AMPs that are actively involved?
What are the various reporting tools in the market?
What is the purpose of indexes?
If RDBMS is halted what will you do ?
What EXPLAIN does in Teradata, what is High confidence, Low confidence and No confidence.. And How we improve the query performance .
How do you check the performance of Teradata Query and list down the basic Performance Tuning steps you use?
What are the steps to create a data model?
Explain parsing engine in teradata?
What is a three-tier data warehouse?
What is meant by MATCHTAG in multiload utility?
Teradata 
