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
- 6540 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 is node? How many nodes and amps used in your previous project?
What are the scenarios in which full table scans occurs?
Why does varchar occupy 2 extra bytes?
What do you mean by teradata intelliflex?
Explain the types of join supports by teradata?
What are the components provided on node?
Explain the parallel data extension in teradata?
How do you see a ddl for an existing table?
Highlight the points of differences between the database and user in Teradata.
What is called partitioned primary index (ppi) and discuss the advantages of using it in a query?
How to identify ppi columns?
What are the steps involved in the process flow of the sql statement through channel attached system?
What is meant by a Channel Driver?
What are the multiload utility limitations?
Explain teradata vs. Redshift?
