Speeding%20Up%20Queries%20with%20Semi-Joins%20and%20Anti-Joins:%20How%20Oracle%20Evaluates%20EXISTS,%20NOT%20EXISTS,%20IN,%20and%20NOT%20IN - PowerPoint PPT Presentation

View by Category
About This Presentation
Title:

Speeding%20Up%20Queries%20with%20Semi-Joins%20and%20Anti-Joins:%20How%20Oracle%20Evaluates%20EXISTS,%20NOT%20EXISTS,%20IN,%20and%20NOT%20IN

Description:

Conventional join access path followed by a sort to remove duplicate rows. ... ( 18 of the 20 rows resulting from the hash join were apparently duplicates. ... – PowerPoint PPT presentation

Number of Views:162
Avg rating:3.0/5.0
Slides: 54
Provided by: rogers1
Learn more at: http://www.nocoug.org
Category:

less

Write a Comment
User Comments (0)
Transcript and Presenter's Notes
About PowerShow.com