how to improve the query perfoemance in teradata.with example?and how explain this in interview?please forward answer
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 |
TCS recently asked this question I have records like below Emp id Empname Salary DateTimestamp 1 AA 6000 20120609:11:30 1 AA 7000 20120609:12:30 1 AA 8000 20120609:01:30 I want to exceute records max timestamp(20120609:01:30)
What happens when a node suffers a downfall?
Highlight the points of differences between the database and user in Teradata.
What is the primary index in teradata?
Which Teradata concept allows more than one model generation?
How teradata makes sure that there are no duplicate rows being inserted when its a set table?
Explain the meaning of Amp?
How do you do backup and recovery in teradata?
What is the use of stored procedures in teradata?
In general, how do you optimze any sql in teradata?
Is multi insert ansi standard?
What is the purpose of joins in teradata?