Invention Grant
- Patent Title: Optimal ranges for relational query execution plans
-
Application No.: US15904192Application Date: 2018-02-23
-
Publication No.: US11080276B2Publication Date: 2021-08-03
- Inventor: Florian Wolf , Norman May , Paul Willems , Kai-Uwe Sattler
- Applicant: SAP SE
- Applicant Address: DE Walldorf
- Assignee: SAP SE
- Current Assignee: SAP SE
- Current Assignee Address: DE Walldorf
- Agency: Mintz Levin Cohn Ferris Glovsky and Popeo, P.C.
- Main IPC: G06F16/2453
- IPC: G06F16/2453

Abstract:
In some implementations, there is provided an apparatus having at least one data processor and at least one memory storing instructions which, when executed by the at least one data processor, cause executing at least a portion of a query execution plan; determining, at an edge including an intermediate result, a cardinality; proceeding with the execution of the query execution plan, when the determined cardinality is within an optimality range associated with the edge; and selecting an alternative query execution plan for execution, when the determined cardinality is outside the optimality range associated with the edge. Related systems and articles of manufacture are also provided.
Public/Granted literature
- US20190266272A1 OPTIMAL RANGES FOR RELATIONAL QUERY EXECUTION PLANS Public/Granted day:2019-08-29
Information query