Invention Grant
- Patent Title: Optimal offset pushdown for multipart sorting
-
Application No.: US15603282Application Date: 2017-05-23
-
Publication No.: US10789249B2Publication Date: 2020-09-29
- Inventor: Paul Willems , Thomas Peh
- 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 ; G06F16/2455

Abstract:
In some aspects, a method, computer program product, and system are provided for query optimization. In some implementations, there may be provided a method including detecting a select query as a candidate for optimization, the select query including an order by, an offset value, and a limit value; determining, in response to the detecting, a modified offset value as the difference between the offset value and a size of a smaller dataset; and performing the select query to form a result set, the select query executed based on at least the modified offset value. Related systems, methods, and articles of manufacture are also described.
Public/Granted literature
- US20180341676A1 OPTIMAL OFFSET PUSHDOWN FOR MULTIPART SORTING Public/Granted day:2018-11-29
Information query