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
- 13634 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
Hi, If anyone has TD 14 Basics dumps or study materials, please share. nirmaaal1991@gmail.com
How many codd's rules are satisfied by teradata database?
What are default access rights in teradata? What explicit right can be given to a user?
What are the various reporting tools in the market?
Highlight the limitations of TPUMP Utility.
Can any one explain me the difference between BTEQ and MLOAD,TUMP. All canbe used for same purpose but still differnt methods. why ?
Which is more efficient group by or distinct to find duplicates?
Can we have an unconnected lkp to lookup a db2 record against a teradata record? Doesnt seem to work. I could be wrong
What is a dimension table?
In general, how do you optimze any sql in teradata?
Explain the most common data types used in teradata?
how can we analyze the locks ?
What is spool space? Why do you get spool space errors? How do trouble-shoot them?
How do you create tables? Exact syntax, and create profiles, users in teradata?
What are the different table types that are supported by teradata?
