What is the difference between IN subselects and
More DBA job interview questions and answers at
What is the difference between IN subselects and EXISTS subselect?
If there is an index on the attributes tested an IN is more efficient since DB2 uses the index for the IN.
Other Job Interview Questions