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
- 11494 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
Explain fallback in teradata?
How many types of joins are there in teradata?
Hi Friends, Please send me Teradata Materials for certifications Thanks in advance !!
If the PMON is not working then how do you manage and monitor all processes, resources and sessions etc.
How to identify ppi columns?
Explain the meaning of Amp?
Is multi insert ansi standard?
In BTEQ, how are the session-mode parameters being set?
How to find duplicates in a table?
While creating table my dba has fallback or no fallback in his ddl. What is that?
What is meant by a node?
What is meant by Teradata Gateway?
Highlight the limitations of TPUMP Utility.
Explain the term 'columns' related to relational database management system?
Explain teradata architecture in detail with a diagram.
