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
- 6775 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 |
I want to write one query How to get Matched records and unmatched records in table?
Why MultiLoad Utility supports only Non Unique Secondary Index(NUSI) in the Target Table ?
How is the teradata different from oracle?
How do you set the session mode parameters in bteq?
where we can use the delimiter in mload? pls let me know
What are the uses of bynets in multi-node systems?
How do you see a ddl for an existing table?
Hi Friends, Please send me Teradata Materials for certifications Thanks in advance !!
how to improve the query perfoemance in teradata.with example?and how explain this in interview?please forward answer
In which phase of the Active Data Warehouse evolution do you use data to determine what will happen?
Give a justifiable reason why Multi-load supports NUSI instead of USI.
Highlight the advantages of PPI(Partition Primary Index).
Teradata 
