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
List out teradata data types?
How to eliminate product joins in a teradata sql query?
Highlight the points of differences between the database and user in Teradata.
What are the different table types that are supported by teradata?
What are different table types used in teradata?
How many sessions of MAX is PE capable of handling at a particular time?
In general, how do you optimze any sql in teradata?
What does Amp contain and what are all the operations that it performs?
Explain and compare pros and cons of start schemas?
What are the frequently used data types in teradata?
What is the difference between teradata and oracle?
What do you mean by teradata intellicloud?
How can bottlenecks be identified?
Highlight the differences between Primary Key and Primary Index.
While creating table my dba has fallback or no fallback in his ddl. What is that?