Invention Grant
- Patent Title: Optimizing the execution order between analytical functions and joins in SQL queries
-
Application No.: US16704934Application Date: 2019-12-05
-
Publication No.: US11409745B2Publication Date: 2022-08-09
- Inventor: Christina Pavlopoulou , Mahbub Hasan , B. Anantha Subramanian , Mohammed Al-Kateb , Awny Kayed Al-Omari , Kashif Abdullah Siddiqui , Robert Matthew Wehrmeister , Mohamed Yassin Eltabakh
- Applicant: Teradata US, Inc
- Applicant Address: US CA San Diego
- Assignee: Teradata US, Inc
- Current Assignee: Teradata US, Inc
- Current Assignee Address: US CA San Diego
- Agent Howard Speight
- Main IPC: G06F16/2453
- IPC: G06F16/2453
Abstract:
Execution of a query invoking an analytical function (AF) is optimized. The query includes a join operation between an AF table and an AuxiliaryTable. A determination is made that the AF includes a plurality of AF properties. Query-level properties about the query are inferred. A determination is made to change an order of the join operation from the plurality of AF properties and query-level properties.
Public/Granted literature
- US20200183935A1 Optimizing the Execution Order between Analytical Functions and Joins in SQL Queries Public/Granted day:2020-06-11
Information query
