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
- 11460 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 functions of a Parser?
What happens when a node suffers a downfall?
What is TPD?
What is the particular designated level at which a LOCK is liable to be applied in Teradata?
What is upsert statement in teradata?
What are the functions of a teradata dba?
Can we collect statistics on table level?
Explain the term 'tables' related to relational database management system?
Mention the procedure via which, we can run Teradata jobs in a UNIX environment.
What are the available join types in teradata?
What are the commands to make a new table, change a table and remove a table in teradata?
Explain and compare pros and cons of snow flake schemas?
List out some of the primary characteristics of teradata.
What are the different table types supported by teradata?
What are the various indexes in teradata? Why are they preferred?
