Can any one please provide me practical example of How to
do the performance tuning in Query??
Answer Posted / subbareddy kake
I will give you example for this....
Select *from emp where deptno=20 and empno:7788
above query will take much time to execute compared to
bellow query
Select *from emp where empno=7788 and deptno=20
becoz first query will take 1st all 20th dept emps and
again it will search for specific empno.but second query
will search first 7788 empno next it will see,that empno is
related to 20th dept or no.
So it will take less time for execution.
Is This Answer Correct ? | 5 Yes | 2 No |
Post New Answer View All Answers
Highlight the limitations of TPUMP Utility.
How can you track login parameters of users in teradata?
What are the uses of bynets in multi-node systems?
If Fast Load Script fails and only the error tables are made available to you, then how will you restart?
What are the multiload utility limitations?
What are the available join types in teradata?
How is the teradata different from oracle?
Is it necessary to add? Quit statement after a bteq query when I am calling it in a unix environment?
What is database exceptions in teradata?
A certain load is being imposed on the table and that too, every hour. The traffic in the morning is relatively low, and that of the night is very high. As per this situation, which is the most advisable utility and how is that utility supposed to be loaded?
how many modules are there in telecome domain?how to explain the architecture?
Explain the term 'primary key' related to relational database management system?
Syntax for case when statement?
How to eliminate product joins in a teradata sql query?
Describe the set operators in teradata.