How does the processing of a correlated subquery differ
from a non correlated subquery?
- 1 Answers
- 6643 Views
- I also Faced
- E-Mail Answers
Answer / s
For every qualifying row in the outer query the correlated
subquery is evaluated. The correlated subquery has
reference to atleast one column of the outer query.
Non-correlated subquery does not make any reference to the
other query. The subquery is only executed once and the
results are used by the outer query to find the qualifying
rows.
| Is This Answer Correct ? | 7 Yes | 1 No |
What is cobol db2?
What is access path in db2?
Which components manage deadlocks in db2?
What is an EXPLAIN in DB2. How and what is the steps followed in EXPLAIN command. Can all the queries be used in EXPLAIN command to check the performance.
What does db2 blu stand for?
What is dbrm?
What is ACQUIRE/RELEASE in BIND?
What is a view? Why use it?
in my project..TEST is db2 8.1 version In PROD it is 7.1 if i do REORG in TEST.. can I use the same REORG jcl with out modification in PROD region (this is DB2 8.1 )? if not, what modification i need to do in my REORG control card?
Is it Possible to declare or create a cursor for UPDATE of table? If yes tell me how? If no Tell me why?
What is the COBOL picture clause of the following DB2 data types: DATE, TIME, TIMESTAMP?
What is bufferpool in db2?
COBOL 
