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
- 11505 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 day to day activities of teradata DBA ?
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 bteq utility in teradata?
Hi send me the Teradata dumps to my id rajeshanantha@yahoo.co.in Thanks Rajesh. A
What are the different functions included in the server software?
What are the different softwares used with their functions in teradata?
How to load specific no.of records using bteq, or fastload,or multiload
If Fast Load Script fails and only the error tables are made available to you, then how will you restart?
What is the opening step in basic teradata query script?
How many sessions of MAX is PE capable of handling at a particular time?
Explain teradata utilities. What is multiload, fast load, tpump?
Steps to create a data model?
What is dimensional modeling?
What is the syntax for case when statement?
Why managing the data is important?
