-
Sort-merge join???
Which of the following queries will mostly likely require a sort-merge join?
Why???
A. Two-table equijoin with no indexes
B. Two tables equijoin with one index
C. Two-table equijoin in which both tables are indexed on the join column
In which case nested loop join is used?
Last edited by janki_mehta; 03-31-2007 at 12:47 PM.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|