Interested to Buy Any Domain ? << Click Here >> for more details...
How do you check the performance of Teradata Query and list
down the basic Performance Tuning steps you use?
- 2 Answers
- 13535 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / tdguy
Refer the explain plan. 1. check for product or nested
joins and try to avoid those joins, as they affect the
performance. 2. try to check the confidence levels of TD.
Collect stats for the columns recommended by TD. 3. In case
of long queries, try to use SI appropriately. Should be
carefully chosen. 4. Check for the usage of temporary
tables. These tables can be used in case any aggregrate
results are needed.
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
Which is more efficient group by or distinct to find duplicates?
What is the opening step in basic teradata query script?
Is it necessary to add? Quit statement after a bteq query when I am calling it in a unix environment?
What are normalization, first normal form, second normal form and third normal form?
How do you determine the number of sessions?
Explain teradata architecture?
What do high confidence, low confidence and no confidence mean in explain plan?
i learn teradata,it is so intersting,now i want teradata certifications ,so any 1 help me to get teradata certifications TD 12 ? email:kdcrazyy@gmail.com
How is the teradata different from oracle?
What is the primary index in teradata?
Hi, If anyone has TD 14 Basics dumps or study materials, please share. nirmaaal1991@gmail.com
What do you mean by parsing?
Can we collect statistics on multiple columns?
What are default access rights in teradata? What explicit right can be given to a user?
Explain the term 'primary key' related to relational database management system?
