how to improve the query perfoemance in teradata.with example?and how explain this in interview?please forward answer
- 2 Answers
- 6022 Views
- IBM, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / gowthami
hIIIIIII.........
BY using indexes and collect statistics we can increase the
query performance
| Is This Answer Correct ? | 1 Yes | 0 No |
How to view every column and the columns contained in indexes in teradata?
Can we load a Multi set table using MLOAD?
Hi frinds pls help me regarding this question WHY usi is two amp operation in teradata? THANKS IN ADVANCE....
Difference between stored procedure and macro?
How do you create a table with an existing structure of another table with data and with no data?
What is logical data model?
Why MultiLoad Utility supports only Non Unique Secondary Index(NUSI) in the Target Table ?
Difference between inner join and outer join?
What do you mean by parsing?
How do you verify a complicated sql?
How do you load Multiple files to a table by using fastload scripts?
Highlight the differences between Primary Key and Primary Index.
Teradata 
