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
If RDBMS is halted what will you do ?
What is the command in bteq to check for session settings ?
Describe the set operators in teradata.
Explain teradata utilities?
What is a sparse index?
What is database exceptions in teradata?
What are the steps involved in the process flow of the sql statement through channel attached system?
Briefly explain each of the following terms related to relational database management system (rdbms) – database, tables, columns, row, primary key and foreign key.
Explain the term 'primary key' related to relational database management system?
What is the particular designated level at which a LOCK is liable to be applied in Teradata?
What is the purpose of joins in teradata and what are the available join types?
What is meant by a node?
What are default access rights in teradata?
Can we collect statistics on table level?
Explain the advantages of partitioned primary index in a query?