Interested to Buy Any Domain ? << Click Here >> for more details...
How does the processing of a correlated subquery differ
from a non correlated subquery?
- 1 Answers
- 7419 Views
- I also Faced
- E-Mail Answers
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 are the rules for db2 programming?
Explain what are the various isolation levels possible?
What is a plan and package in db2?
What is a cursor in programming?
What is release/acquire in bind?
What's The Error Code For Unique Index Voilation?
How do I add a column in db2?
What is data manager?
What is buffer pool?
What is precompiler in db2?
Why select is not preferred in embedded sql programs?
What kind of database is db2?
What is db2 purescale?
What are sqlcodes –803,-805, -811, -818,-904,-911,-913,-101, +100?
How and when does the db2 enforces the unique key?
