How do you check the performance of Teradata Query and list
down the basic Performance Tuning steps you use?
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
What is the purpose of upsert command?
If RDBMS is halted what will you do ?
What is the function of parser component in teradata?
What is the basic syntax for teradata select statement?
How to eliminate product joins in a teradata sql query?
What are the various indexes in teradata?
What is the use of teradata system software?
How to select first n records in teradata?
what are the day to day activities of teradata DBA ?
How can you track login parameters of users in teradata?
What is teradata? Also, list out some of the primary characteristics of teradata.
What does Amp contain and what are all the operations that it performs?
What do you mean by caching in teradata?
What is the meaning of Caching in Teradata?
What are the design features involved in teradata?