- Patent Title: Methods for substituting a semi-join operator with alternative execution strategies and selection methods to choose the most efficient solution under different plans
-
Application No.: US16394998Application Date: 2019-04-25
-
Publication No.: US11468064B2Publication Date: 2022-10-11
- Inventor: Pit Fender , Benjamin Schlegel , Matthias Brantner , Cagri Balkesen , Nipun Agarwal
- Applicant: Oracle International Corporation
- Applicant Address: US CA Redwood Shores
- Assignee: Oracle International Corporation
- Current Assignee: Oracle International Corporation
- Current Assignee Address: US CA Redwood Shores
- Agency: Hickman Becker Bingham Ledesma LLP
- Main IPC: G06F16/2453
- IPC: G06F16/2453 ; G06F16/248 ; G06F16/2455

Abstract:
The manner in which tables are joined can affect the outcome of the query and database performance. Example types of join operations include semi-join and inner-join. The techniques described herein are approaches that may be used to substitute a semi-join operator with an inner-join operator and may be used to transform and optimize representations of queries.
Public/Granted literature
Information query