Interested to Buy Any Domain ? << Click Here >> for more details...
how to improve the query perfoemance in teradata.with example?and how explain this in interview?please forward answer
- 2 Answers
- 6674 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / tdguy
Performance tuning increases with experience. Some tips
are: Analyze the plan displayed by TD. This would give
enough information about the query, data and performance.
Check for confidence levels. Try to identify the type of
joins. Avoid product, cartesian product and nested joins.
1. try to avoid unnecessary joins 2. Try to join using
unique value columns 3. collect stats 4. Use secondary
index appropriately 5. Use join index, if necessary 6.
Split the query, if necessary.
Again, see the plan and repeat the steps.
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
What are default access rights in teradata?
what is sysdba and sysdbc ? which has high priority ?
If I wanted to run a TPump job only once per day - basically working on a file that is produced once per day - how would you set up the parameters for that sort of job ?
Hi, If anyone has TD 14 Basics dumps or study materials, please share. nirmaaal1991@gmail.com
What is the difference between teradata and oracle?
Explain the most common data types used in teradata?
Explain BYNET.
How would you load a very large file in teradata in general? What utility would you use for it? Why?
What are the primary characteristics of the Teradata.
What does Amp contain and what are all the operations that it performs?
What is real time and near real time data warehousing?
Why does varchar occupy 2 extra bytes?
What is the difference between global temporary tables and volatile temporary tables?
What do you mean by teradata sql assistant?
What is bteq script in teradata?
