|
What is the difference between IN subselects and EXISTS subselect?
COBOL SQL 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 Interview Questions
| 