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
- 11431 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 is sysdba and sysdbc ? which has high priority ?
What are default access rights in teradata? What explicit right can be given to a user?
Why are oltp database designs not generally a good idea for a data warehouse?
What exactly do you know about catching in teradata?
What are the different table types supported by teradata?
Syntax for case when statement?
Explain and compare pros and cons of start schemas?
Comment whether bottleneck is an error or not.
What are the uses of client software involved in teradata?
Why managing the data is important?
What are the various indexes in teradata? How to use them? Why are they preferred?
Hi, If anyone has TD 14 Basics dumps or study materials, please share. nirmaaal1991@gmail.com
Explain the term 'columns' related to relational database management system?
How to explain project Architecture and flow in teradata interviews?Can please anyone help on this? Am new to teradata.
What is the syntax for case when statement?
