I have been asked a generic question as to what is the Difference between Corrrelated Subquery and Joins? The more important thing which one is really more efficient!
I have read topics from many forums and questions/answers but not really a concrete difference in terms of performance, at max I read that it all depends on the Optimizer, the complexity of the query and indexes that are used.
Do we really have a performance difference in general?