Compare a subselect to a join. Any subselect can be rewritten as a join, but not vice versa. Joins are usually more efficient as join rows can be returned immediately, subselects require a temporary work area for inner selects results while processing the outer select.

 

This Question is not yet answered!

 
 

Related Answered Questions

 

Related Open Questions