Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between IN and Exists in Oracle?
- 4 Answers
- 18282 Views
- Deloitte, I also Faced
- E-Mail Answers
Answer Posted / sri
when the condition is in a subquery then in will be used
where if there is a condition in superquery
(parent) exists will be used. Usage of IN will improve the
performance
| Is This Answer Correct ? | 0 Yes | 10 No |
Post New Answer View All Answers
what is the hint? how to use it to reduce the query processing in program?
EXL informatica Questions
Explain the difference between mapping parameter and mapping variable?
What is persistent lookup cache?
Explain the scenario which compels informatica server to reject files?
What are the settings that you use to configure the joiner transformation?
Explain pushdown optimization and types in informatica
What is a dimensional model?
How can you generate reports in informatica?
Global and Local shortcuts. Advantages.
What will happen if the select list columns in the custom override sql query and the output ports order in sq transformation do not match?
What are the limitations of joiner transformation?
What does refresh system mean, and what are its distinctive choice?
What is confirmed fact in dataware housing?
Tell me can we override a native sql query within informatica? Where do we do it? How do we do it?
