What is the difference between IN and Exists in Oracle?
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 a code page?
What are connected or unconnected transformations?
What is aggregate cache in aggregator transformation?
What are the modules in Power Center
Hi friends I want to know about what r the dimensions in the banking porjects and genarally how many tables r in project ?
How do you load only null records into target?
Explain informatica architecture - version 8 / 9
Informatica Checkpoints
What is the benefit of partitioning a session?
What does role playing dimension mean?
What are multi-group transformations?
What is standalone command task?
What is repository manager?
what is the size of your data warehousing?
What is the status code in stored procedure transformation?