What is the difference between IN subselects and

More DBA job interview questions and answers at http://dba.fyicenter.com/Interview-Questions/

(Continued from previous question...)

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. ( IN for index is the mnemonic).

(Continued on next question...)

Other Job Interview Questions

• The only place of VSAM KSDS in DB2 is
• What is a SELECT statement ?
• What is the best lock size that you could use when you create a tablespace?
• How does the processing of a correlated subquery differ from a non correlated subquery ?
• What are delete-connected tables ?
• What is FREEPAGE and PCTFREE in TABLESPACE createion?
• When can an insert of a new primary key value threaten referential integrity ?
• What do you mean by NOT NULL ? When will you use it ?
• How to see the structure of DB2 table?
• What are column-name qualifier used ?
• More...