How does the processing of a correlated subquery differ
from a non correlated subquery?
Answer Posted / 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 |
Post New Answer View All Answers
What is db2 purescale?
What is node in db2?
What is the difference between cursor stability and repeatable read isolation levels?
What are db2 objects?
What is load replace in db2?
Explain in detail about buffer manager and its functionalities?
What is the use of predicate?
How will you return the number of records in table?
What is the role of data manager in the db2 database?
How many databases can be created inside an instance in db2 ?
Is db2 relational database?
SQLCODE = -199, ERROR: ILLEGAL USE OF KEYWORD CHAR, TOKEN KEY was expected
Explain dclgen.
What are db2 tables?
How is a typical db2 batch pgm executed?