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
- 11680 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
Explain vproc in teradata?
What happens when a node suffers a downfall?
What are the advantages of teradata?
Explain Teradata performance tuning and optimization?
Hi Friends, Please send me Teradata Materials for certifications Thanks in advance !!
What do you mean by fastexport in teradata?
Define views in teradata with general syntax.
What are the different design perspectives used in teradata?
What is stored procedure in teradata?
How would you load a very large file in teradata in general? What utility would you use for it? Why?
What is the difference between union and union all in teradata?
Explain the teradata primary index mechanics in detail with a diagram.
What is partitioned primary index (ppi)?
Comment whether bottleneck is an error or not.
Explain teradata utilities?
