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
- 11850 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 is the meaning of Caching in Teradata?
Explain and compare pros and cons of snow flake schemas?
What are the joins in teradata and how many types of joins are there in teradata?
What is spool space? Why do you get spool space errors? How do trouble-shoot them?
Can any one explain me the difference between BTEQ and MLOAD,TUMP. All canbe used for same purpose but still differnt methods. why ?
In Teradata, what is the significance of UPSERT command?
What is the use of teradata system software?
What is real time and near real time data warehousing?
What are the design features involved in teradata?
How to Extract data from multiple legacy systems?
What is bteq utility in teradata?
What is the command in bteq to check for session settings ?
What does sleep function does in fast load?
What is the difference between teradata and basic rdbms?
Why managing the data is important?
