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
- 11839 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 is the difference between teradata and oracle?
Which is faster fastload or multiload?
What is meant by a Clique?
What is the difference between teradata and basic rdbms?
Explain BYNET.
What is the purpose of joins in teradata and what are the available join types?
What is a clique?
What is the use of having index on table?
What are the advantages of teradata?
What is the purpose of joins in teradata?
What does sleep function does in fast load?
What are some primary characteristics of teradata?
How do you see a ddl for an existing table?
In Teradata, how do we Generate Sequence?
What do you mean by teradata intelliflex?
