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
- 11831 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
How is MLOAD Teradata Server restarted after execution?
How do you do backup and recovery in teradata?
What is the command in bteq to check for session settings ?
What happens in a conflict? How do you handle that?
What are the different table types supported by teradata?
What are the functions of a teradata dba?
What is called partitioned primary index (ppi) and discuss the advantages of using it in a query?
What are default access rights in teradata? What explicit right can be given to a user?
What are the primary characteristics of the Teradata.
hi frnds i want to learn teradata utilities and teradata dba real time. i have 1+ years of experience in teradata. so i want to go deeply in Tearada. plz let me know at my email id who r best to learn from. im lookng for a realtime guy in HYD or Banglr. Thanks in advance. Rajesh my email-id: rajeshmss87@gmail.com
Which is more efficient group by or distinct to find duplicates?
What is the opening step in basic teradata query script?
Mention a few of the ETL tools that come under Teradata.
How can we check the version of Teradata that we are using currently?
What is difference between user and database in teradata?
