Can any one please provide me practical example of How to
do the performance tuning in Query??
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
Why teradata is used?
What's the difference between timestamp (0) and timestamp (6)?
what are the day to day activities of teradata DBA ?
What is a three-tier data warehouse?
What is spool space?
Hi, If anyone has TD 14 Basics dumps or study materials, please share. nirmaaal1991@gmail.com
Explain the term 'primary key' related to relational database management system?
Can you connect multiload from ab initio?
What is inner join and outer join?
What are the available join types in teradata?
How many sessions of MAX is PE capable of handling at a particular time?
Which is faster fastload or multiload?
What are the things to be considered while creating secondary index?
Write a program to show the parser component used in teradata?
Is multi insert ansi standard?