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
- 11637 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
What happens in a conflict? How do you handle that?
How can you track login parameters of users in teradata?
What is the basic syntax for teradata select statement?
What are the joins in teradata?
What are the functions performed by bynet?
What are differences between teradata and ansi session modes in teradata?
What are default access rights in teradata?
What is a sparse index?
What are the steps involved in the process flow of the sql statement through channel attached system?
Explain PDE.
What does sleep function does in fast load?
Backup Script was blocked you are unable to archive the data now. how do you analyze it and where do you identify ?
What is the difference between global temporary tables and volatile temporary tables?
Steps to create a data model?
What are the different functions included in the server software?
