how to improve the query perfoemance in teradata.with example?and how explain this in interview?please forward answer
- 2 Answers
- 5601 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 |
Highlight the differences between Primary Key and Primary Index.
What is the purpose of joins in teradata?
What is a level of granularity of a fact table?
i am pursuing mca and i want to do tera data .so plz suggest me the best institue in hydrabad who teach real tym scenerio.
What can be achieved by using the teradata rdbms?
What is spool space?
What is real time and near real time data warehousing?
How will you solve the problem that occurs during update?
Explain Teradata performance tuning and optimization?
My table got locked during mload due to a failed job. What do I do to perform other operations on it?
id name gender 1 Ram Female 2 Kumar Female 3 sathish Female 4 Santhya Male 5 Durga Male 6 Priya Male This is my input...how to change Gender Male to Female & Female to Male??? Write sql query for this question???
Can we take collect stats on Dervied Tables and Volitable tables, What is Golabal Temporary table what is the use of this Golabal Temporary table ,When we create any kind table in Teradata it will show in Golabal Temporary table
Teradata 
