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
- 11642 Views
- Amdocs, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / karthik
Take a look at the query which is been tuned and check
whether the columns used in the join conditions of multiple
tables are a part of primary index for the corresponding
tables.In addition to this makes sure that the tables used
in the query is collected with stats.Meanwhile as far as
possible make use of subqueries rather than the whole
table(can be used if the table is big).
| Is This Answer Correct ? | 4 Yes | 1 No |
Answer / subbareddy kake
I will give you example for this....
Select *from emp where deptno=20 and empno:7788
above query will take much time to execute compared to
bellow query
Select *from emp where empno=7788 and deptno=20
becoz first query will take 1st all 20th dept emps and
again it will search for specific empno.but second query
will search first 7788 empno next it will see,that empno is
related to 20th dept or no.
So it will take less time for execution.
| Is This Answer Correct ? | 5 Yes | 2 No |
Answer / adarsh
Ask someone from the performance tuning team,
they will be able to answer your question.
Regards
| Is This Answer Correct ? | 5 Yes | 3 No |
Answer / tdguy
Beauty of teradata lies in explain plan. It explains
everything about your query. Use it effectively to find the
opportunities for performance tuning.Avoid unnecessary
joins like product joins, use secondary index and collect
stats.
| Is This Answer Correct ? | 1 Yes | 0 No |
While creating table my dba has fallback or no fallback in his ddl. What is that?
what are the day to day activities of teradata DBA ?
What are the steps involved in the process flow of the sql statement through channel attached system?
What are the enhanced features in teradata v2r5 and v2r6?
In BTEQ, how are the session-mode parameters being set?
Difference between multiload and tpump?
i learn teradata,it is so intersting,now i want teradata certifications ,so any 1 help me to get teradata certifications TD 12 ? email:kdcrazyy@gmail.com
"pravalli nagireddy" record is there in address column but i want display only 'nagireddy' from the main string what is query for that pls tell me
Write a single SQL to delete duplicate records from the a single table based on a column value. I need only Unique records at the end of the Query.
Pls any body reply for this question. Which circumstance does the optimizing choose a product join? Thanks for advance
What are the joins in teradata?
What is spool space?
Teradata 
