Interested to Buy Any Domain ? << Click Here >> for more details...
Can any one please provide me practical example of How to
do the performance tuning in Query??
- 5 Answers
- 11439 Views
- Amdocs, I also Faced
- E-Mail Answers
Answer Posted / yuvaevergreen
There is no specific answer for this question.It depends on
various factors. But in general,
1.Do a explain and understand the plan for the query.Act
accordingly to reduce the load and time.
2.Avoid joins as far as possible(case can be used).
3.Use secondary index to speed up the queries.
4.Use collect stats to improve the performance.
Add to the above if you find more.
| Is This Answer Correct ? | 8 Yes | 0 No |
Post New Answer View All Answers
How many types of joins are there in teradata?
How many codd's rules are satisfied by teradata database?
What is called partitioned primary index (ppi) and discuss the advantages of using it in a query?
What is the purpose of indexes?
Explain the term 'tables' related to relational database management system?
What is primary index and secondary index?
hi frnds i want to learn teradata utilities and teradata dba real time. i have 1+ years of experience in teradata. so i want to go deeply in Tearada. plz let me know at my email id who r best to learn from. im lookng for a realtime guy in HYD or Banglr. Thanks in advance. Rajesh my email-id: rajeshmss87@gmail.com
What are the joins in teradata and how many types of joins are there in teradata?
Explain and compare pros and cons of start schemas?
Explain the most common data types used in teradata?
Difference between star and snowflake schemas?
What is the syntax for case when statement?
Can we have two time dimensions in a schema(either star or snow flake)? For ex if we want joining date of employee and if we want today's sales with time whether can we have two time dimensions for accommodating above tasks?
What are the different functions included in the server software?
what are the uses of fact table and dimension table in banking project?
