Invention Grant
- Patent Title: Inferred predicates for query optimization
-
Application No.: US17114823Application Date: 2020-12-08
-
Publication No.: US11379485B2Publication Date: 2022-07-05
- Inventor: Muhammed Sharique
- Applicant: SAP SE
- Applicant Address: DE Walldorf
- Assignee: SAP SE
- Current Assignee: SAP SE
- Current Assignee Address: DE Walldorf
- Agency: Buckley, Maschoff & Talwalkar LLC
- Main IPC: G06F16/2455
- IPC: G06F16/2455 ; G06F16/2453 ; G06F16/215 ; G06F16/22

Abstract:
A system includes reception of a query comprising a join operation on a first table and a second table and a join condition associated with the join operation, determination of a first table column of the first table and a second table column of the second table associated with the join condition, determination of an inferred predicate of the query, the inferred predicate associated with a first column dictionary of the first table column and a second column dictionary of the second table column, determination of a cost of using the inferred predicate to perform the join operation, determination of a plurality of query execution plans to execute the join operation using the inferred predicate, and determination of a cost of each of the plurality of query execution plans based on the cost of using the inferred predicate to perform the join operation.
Public/Granted literature
- US20220179854A1 INFERRED PREDICATES FOR QUERY OPTIMIZATION Public/Granted day:2022-06-09
Information query