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
- 11679 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
List out teradata data types?
How many sessions of MAX is PE capable of handling at a particular time?
Explain the meaning of Amp?
What is meant by a Clique?
Backup Script was blocked then you are unable to archive the data. how do you analyze it and where do you identify ?
What does Amp contain and what are all the operations that it performs?
Highlight the differences between Primary Key and Primary Index.
In Teradata, what is the significance of UPSERT command?
What are the main components of teradata system?
What is the opening step in basic teradata query script?
how can we analyze the locks ?
what is object level locking ? where do appear this type of locking ?
Briefly explain each of the following terms related to relational database management system (rdbms) – database, tables, columns, row, primary key and foreign key.
How to eliminate product joins in a teradata sql query?
Difference between multiload and tpump?
