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
Explain how spool space is used.
What is meant by a Virtual Disk?
why use references rather than pointers in the public api, particularly for arguments which are modified?
Explain teradata architecture?
What is the purpose of joins in teradata and what are the available join types?
Highlight a few of the advantages that ETL tools have over Teradata.
What are the components provided on node?
How to select first n records in teradata?
What is meant by a Least Cost Plan?
How you will check the version of teradata?
What exactly do you know about catching in teradata?
Explain some differences between mpp and smp?
What is spool space? Why do you get spool space errors?
Define views in teradata with syntax.
Explain the meaning of Amp?