First page Back Continue Last page Graphics
USE_MERGE Hints
USE_MERGE hint forces a sort-merge join:
Notes:
The example in the slide is forcing a sort-merge join. Note that even though a sort-merge join is used one of the sorts is avoided by index access to the employee table.