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
- 11638 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 the meaning of Amp?
In Teradata, how do we Generate Sequence?
During the Display time, how is the sequence generated by Teradata?
What are default access rights in teradata?
In a table can we use primary key in one column and in another column both unique and not null constrains.if yes how?
What is the purpose of using case expression in teradata?
Hi, If anyone has TD 14 Basics dumps or study materials, please share. nirmaaal1991@gmail.com
Let us say there is a file that consists of 100 records out of which we need to skip the first and the last 20 records. What will the code snippet?
How to explain project Architecture and flow in teradata interviews?Can please anyone help on this? Am new to teradata.
if collect stats but it show low confidence why?
What exactly do you know about catching in teradata?
What is meant by Teradata Gateway?
How many types of joins are there in teradata?
Highlight the limitations of TPUMP Utility.
why use references rather than pointers in the public api, particularly for arguments which are modified?
