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
- 6682 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 |
Difference between star and snowflake schemas?
What is database exceptions in teradata?
Explain the types of join supports by teradata?
What is the difference between teradata and basic rdbms?
There is a column with date in it. If I want to get just month how it can be done? Can I use sub string?
What is a node in teradata? Explain
How to run a query in teradata?
Aborted in Phase 2 data acquistion completed in fastload?
Explain amp in teradata?
Highlight a few of the advantages that ETL tools have over Teradata.
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?
How to Skip or Get first and Last Record from Flat File through MultiLoad and TPUMP Utility?
Teradata 
