Can any one please provide me practical example of How to
do the performance tuning in Query??
- 5 Answers
- 10350 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 things to be considered while creating secondary index?
What is called partitioned primary index (ppi) and discuss the advantages of using it in a query?
What is partitioned primary index (ppi)?
What are the different table types that are supported by teradata?
Explain the teradata primary index mechanics in detail with a diagram.
Can you fastexport a field, which is primary key by putting equality on that key?
In Teradata, what is the significance of UPSERT command?
If the PMON is not working then how do you identify and monitor all the processes, resources and sessions ?
How is MLOAD Client System restarted after execution?
In the Primary Index, what is the score of AMPs that are actively involved?
How would you load a very large file in teradata in general?
If I wanted to run a TPump job only once per day - basically working on a file that is produced once per day - how would you set up the parameters for that sort of job ?
What is inner join and outer join?
Explain and compare pros and cons of snow flake schemas?
What do you mean by ttu in teradata?
