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
- 11848 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
Explain teradata utilities?
What are the 5 phases in a multiload utility?
How do you create tables? Exact syntax, and create profiles, users in teradata?
what are the day to day activities of teradata DBA ?
While creating table my dba has fallback or no fallback in his ddl. What is that?
What is the difference between fastload and multiload? Which one is faster?
how can we analyze the locks ?
If Fast Load Script fails and only the error tables are made available to you, then how will you restart?
any one answer me how they can analyzing the project using data ware housing?
In general, how do you optimze any sql in teradata?
What are the available primary index types in teradata.
How does hashing happens in teradata?
Give the sizes of SMALLINT, BYTEINT and INTEGER.
What are the frequently used data types in teradata?
What are differences between teradata and ansi session modes in teradata?
