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
- 13675 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
What is the multi-insert?
What are the steps to create a data model?
What is the use of having index on table?
What is the primary index in teradata?
What is the function of parser component in teradata?
What is meant by a Parsing Engine?
What are the different softwares used with their functions in teradata?
What do you mean by caching in teradata?
My table got locked during mload due to a failed job. What do I do to perform other operations on it?
What can be achieved by using the teradata rdbms?
What are the components provided on node?
Explain the term 'database' related to relational database management system?
Where is teradata rdbms used?
What is the purpose of joins in teradata?
If a Node is busy what are the steps you can take to avoid ?
