How does the processing of a correlated subquery differ
from a non correlated subquery?
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 bufferpool in db2?
What is cursor stability?
How do you pull up a query which was previously saved in qmf?
Can we use select * statement in cobol program without giving field names ???
what is utility for parm lib
How does one bind 2 versions of a CICS transaction with the same module name in two different CICS regions that share the same DB2 subsystem?
What is the use of predicate?
What is page size in db2?
Is it Possible to read from PS file and write it to database by using dynamic sql(execute immediate)
What is auditing?
List down the data types in the db2 database.
What are the uses of db2 optimizer?