InterviewSolution
Saved Bookmarks
InterviewSolution
| 1. |
Explain Nested Join? |
|
Answer» In nested JOINS, for each tuple in the outer join relation, the system scans the ENTIRE inner-join relation and appends any tuple that match the join-condition to the RESULT SET. In nested joins, for each tuple in the outer join relation, the system scans the entire inner-join relation and appends any tuple that match the join-condition to the result set. |
|