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
- 7471 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 |
why should we bind the DB2 program . What if we did not BIND a BD2 program ??
9 Answers Infosys, TCS, Xansa,
Lot of updates have been done on a table due to which indexes have gone haywire. What do you do?
what is a corelated subquerry?
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.
Can any one tell me about Restart logic in DB2.
How do I add a column to a table in db2?
What is null value in db2?
What is buffer pool?
What is the maximum number of columns in a db2 table?
What are the full forms of spufi and dclgen and why are they used?
What is db2 command?
What are the various data types available in db2?
COBOL 
