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
- 11499 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 is the teradata different from oracle?
Explain the term 'database' related to relational database management system?
Which is more efficient group by or distinct to find duplicates?
What are the functions of a Parser?
Highlight the differences between Primary Key and Primary Index.
How do you create tables? Exact syntax, and create profiles, users in teradata?
Highlight the points of differences between the database and user in Teradata.
Is multi insert ansi standard?
What are the scenarios in which full table scans occurs?
Can we have an unconnected lkp to lookup a db2 record against a teradata record? Doesnt seem to work. I could be wrong
How is MLOAD Client System restarted after execution?
While creating table my dba has fallback or no fallback in his ddl. What is that?
Name the five phases that come under MultiLoad Utility.
Difference between multiload and tpump?
What is the use of having index on table?
