Can any one please provide me practical example of How to
do the performance tuning in Query??
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 do you define Teradata?
What are differences between teradata and ansi session modes in teradata?
Can any one explain me the difference between BTEQ and MLOAD,TUMP. All canbe used for same purpose but still differnt methods. why ?
Explain some differences between mpp and smp?
Explain the term 'primary key' related to relational database management system?
How to identify ppi columns?
In general, how do you optimze any sql in teradata?
What is multi insert?
what is object level locking ? where do appear this type of locking ?
Explain parsing engine in teradata?
Explain the term 'row' related to relational database management system?
How to explain project Architecture and flow in teradata interviews?Can please anyone help on this? Am new to teradata.
What are the different softwares used with their functions in teradata?
Why do you get spool space errors? How do trouble-shoot them?
What are the functions performed by bynet?