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
- 13754 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
Let us say there is a file that consists of 100 records out of which we need to skip the first and the last 20 records. What will the code snippet?
Explain the term 'primary key' related to relational database management system?
What are the different functions performed in development phase?
How many tables can you join in v2r5?
What is the primary index in teradata?
What are the uses of bynets in multi-node systems?
hi frnds i want to learn teradata utilities and teradata dba real time. i have 1+ years of experience in teradata. so i want to go deeply in Tearada. plz let me know at my email id who r best to learn from. im lookng for a realtime guy in HYD or Banglr. Thanks in advance. Rajesh my email-id: rajeshmss87@gmail.com
what are the uses of fact table and dimension table in banking project?
What is logical data model?
What is TPD?
What do you mean by ttu in teradata?
What is meant by Teradata Gateway?
What do you mean by caching in teradata?
What do you mean by fastexport in teradata?
What are the functions involved in shared information architecture?
