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
- 11432 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 is real time and near real time data warehousing?
What is primary index and secondary index?
Differentiate primary key and partition key?
If I wanted to run a TPump job only once per day - basically working on a file that is produced once per day - how would you set up the parameters for that sort of job ?
Is multi insert ansi standard?
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?
What are the available primary index types?
What is called partitioned primary index (ppi)?
What is dimensional modeling?
What is the difference between union and union all in teradata?
i learn teradata,it is so intersting,now i want teradata certifications ,so any 1 help me to get teradata certifications TD 12 ? email:kdcrazyy@gmail.com
How teradata makes sure that there are no duplicate rows being inserted when its a set table?
Explain and compare pros and cons of start schemas?
What type of indexing mechanism do we need to use for a typical data warehouse?
What are some primary characteristics of teradata?
