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
- 11660 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
If the PMON is not working then how do you manage and monitor all processes, resources and sessions etc.
Highlight all the modes that are present under Confidence Level.
What are the design features involved in teradata?
What is the multi-insert?
Give the sizes of SMALLINT, BYTEINT and INTEGER.
What is meant by a dispatcher?
How to explain project Architecture and flow in teradata interviews?Can please anyone help on this? Am new to teradata.
Explain the term 'row' related to relational database management system?
tomorrow i have interview in infosys.can someone pour any suggestions or any interview questions. thank you
If the PMON is not working then how do you identify and monitor all the processes, resources and sessions ?
If a Node is busy what are the steps you can take to avoid ?
How does hashing happens in teradata?
What are the available primary index types?
What are the multiload utility limitations?
What is the use of fallback?
