What is the difference between IN and Exists in Oracle?
- 3 Answers
- 14527 Views
- Deloitte, I also Faced
- E-Mail Answers
Answer Posted / ram
exists improves the performance because it returns boolian
value where as 'in' is not...so exists simplyfies internal
calculations....
| Is This Answer Correct ? | 9 Yes | 1 No |
Post New Answer View All Answers
is it possible to index the data in cache of lkp transformation ?
write a query to retrieve the latest records from the table sorted by version(scd)
where to store informatica rejected data? How to extract the informatica rejected data?
How can we handle two sessions in informatica?
Explain how many types of dimensions are available in informatica?
How to convert multiple rows to single row (multiple columns) in informatica
In informatica workflow manager, how many repositories can be created?
Workflow is long running due to long running sql query so when we refer the query plan it tells the issue is due to partition of the db table. How to handle this?
Explain about Informatica server process that how it works relates to mapping variables?
Explain the tuning lookup transformation - informatica
What is option by which we can run all the sessions in a batch simultaneously?
What is data transformation manager process?
What is workflow? What are the components of workflow manager?
Write the program through which the records can be updated?
Design a mapping to load the cumulative sum of salaries of employees into target table?
