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
- 11630 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
Did you write stored procedures in teradata?
How can bottlenecks be identified?
What are aggregate tables? How do you design them using teradata?
tomorrow i have interview in infosys.can someone pour any suggestions or any interview questions. thank you
What are the different functions performed in development phase?
What are the uses of bynets in multi-node systems?
List out all forms of LOCKS that are available in Teradata.
What is called partitioned primary index (ppi)?
What interface is used to connect to windows based applications?
What is the opening step in basic teradata query script?
Explain vproc in teradata?
When tpump is used instead of multiload?
Highlight a few of the important components of Teradata?
Explain teradata utilities. What is multiload, fast load, tpump?
What are different table types used in teradata?
