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
- 13664 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 are the various indexes in teradata? Why are they preferred?
When tpump is used instead of multiload?
How do you verify a complicated sql?
How to write the query . eid enm doj dob i want to display the names who worked more than 25 years .
What is the purpose of using case expression in teradata?
What is node? How many nodes and amps used in your previous project?
Can we collect statistics on table level?
Hi Friends, Please send me Teradata Materials for certifications Thanks in advance !!
What is primary index and secondary index?
What is collect statistics?
How to load specific no.of records using bteq, or fastload,or multiload
Name the five phases that come under MultiLoad Utility.
What is the use of fallback?
How do you create tables? Exact syntax, and create profiles, users in teradata?
What are types of partition primary index (ppi) in teradata?
