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