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
- 11661 Views
- Amdocs, I also Faced
- E-Mail Answers
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
What are the components provided on node?
What are the various indexes in teradata? Why are they preferred?
What is bteq script in teradata?
Why teradata is used?
How teradata makes sure that there are no duplicate rows being inserted when its a set table?
What is the difference between union and union all in teradata?
What tools would you use for that?
Explain teradata architecture?
Define views in teradata with syntax.
What is bteq utility in teradata?
Did you write stored procedures in teradata?
What happens in a conflict? How do you handle that?
What are the advantages of teradata?
How can you track login parameters of users in teradata?
How to Extract data from multiple legacy systems?
