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
- 6676 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 do we write scripts in unix how to execute scripts in real time anybody please needfull or give me number i will cal u
Find 2 highest sal from each dept who have completed 5 year in org
If the script is aborted. why it is aborted and how can you identify ?
What are the joins in teradata?
how can i answer for question like teradat architecture in interveiw
Explain the most common data types used in teradata?
What's the difference between timestamp (0) and timestamp (6)?
what is a multi statement request in TD? what is the diif b/w V2R5 & TD12? what is the diff b/w MACRO & STORED PROCEDURE?
Define views in teradata with general syntax.
What do you mean by caching in teradata?
If the PMON is not working then how do you identify and monitor all the processes, resources and sessions ?
Hash collision?
Teradata 
