Interested to Buy Any Domain ? << Click Here >> for more details...
Can any one please provide me practical example of How to
do the performance tuning in Query??
- 5 Answers
- 11438 Views
- Amdocs, I also Faced
- E-Mail Answers
Answer Posted / tdguy
Beauty of teradata lies in explain plan. It explains
everything about your query. Use it effectively to find the
opportunities for performance tuning.Avoid unnecessary
joins like product joins, use secondary index and collect
stats.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What are the various etl tools in the market?
Explain and compare pros and cons of start schemas?
In the Primary Index, what is the score of AMPs that are actively involved?
What is the use of stored procedures in teradata?
Explain how spool space is used.
Explain the term 'row' related to relational database management system?
What does sleep function does in fast load?
Syntax for case when statement?
Did you write stored procedures in teradata?
Why managing the data is important?
What is the difference between fastload and multiload? Which one is faster?
What is partitioned primary index (ppi)?
What is the basic syntax for teradata select statement?
Highlight the limitations of TPUMP Utility.
What is oltp?
