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
- 11687 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 are the uses of fact table and dimension table in banking project?
What are the components used in smp and massively parallel processing (mpp) machines?
How to eliminate product joins in a teradata sql query?
What is the purpose of joins in teradata?
Explain the term 'database' related to relational database management system?
What is bteq script in teradata?
What is oltp?
What is upsert statement in teradata?
Highlight the limitations of TPUMP Utility.
Highlight a few of the important components of Teradata?
What is the function of parser component in teradata?
Give the sizes of SMALLINT, BYTEINT and INTEGER.
How to Extract data from multiple legacy systems?
Describe primary index in teradata. And what are the available primary index types?
What is multi insert?
