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
- 6654 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 |
What do you mean by teradata intellicloud?
How is MLOAD Client System restarted after execution?
In general, how do you optimze any sql in teradata?
What is spool space? Why do you get spool space errors?
Where we use PPI in real time??? What is the disadvantages of PPI?
A certain load is being imposed on the table and that too, every hour. The traffic in the morning is relatively low, and that of the night is very high. As per this situation, which is the most advisable utility and how is that utility supposed to be loaded?
What is partitioned primary index (ppi)?
If the query is NOT WRITTEN PROPERLY then what are the recommendations you can give to the developer ?
What are the 5 phases in a multiload utility?
What is TPD?
Which is more efficient group by or distinct to find duplicates?
why use references rather than pointers in the public api, particularly for arguments which are modified?
Teradata 
