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
- 11656 Views
- Amdocs, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
What are the design features involved 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 amp in teradata?
What is the use of teradata system software?
Explain fallback in teradata?
What is smp and mpp platforms?
How many types of joins are there in teradata?
What is meant by a node?
Explain fastload in teradata?
Can you connect multiload from ab initio?
What is collect statistics?
What is teradata? What are some primary characteristics of teradata?
Why do you get spool space errors? How do trouble-shoot them?
What is called partitioned primary index (ppi)?
What interface is used to connect to windows based applications?
