DBA > Job Interview Questions > DB2 ( IBM Database 2 ) Interview Questions
Compare a subselect to a join?
More DBA job interview questions and answers at http://dba.fyicenter.com/Interview-Questions/
(Continued from previous question...)
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.
(Continued on next question...)
Other Job Interview Questions