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
- 11829 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
During the Display time, how is the sequence generated by Teradata?
What do you mean by ttu in teradata?
Highlight a few of the important components of Teradata?
Differentiate database data and data warehouse data?
what are the day to day activities of teradata DBA ?
What are aggregate tables? How do you design them using teradata?
Explain the term 'primary key' related to relational database management system?
What is a dimension table?
What is teradata and why it is used?
What are the advantages of teradata?
What are the steps to create a data model?
What does sleep function does in fast load?
Is it necessary to add? Quit statement after a bteq query when I am calling it in a unix environment?
What are the 5 phases in a multiload utility?
What are the different functions included in the server software?
