Invention Grant
- Patent Title: Global query hint specification
-
Application No.: US15150363Application Date: 2016-05-09
-
Publication No.: US10311055B2Publication Date: 2019-06-04
- Inventor: Neil Thombre , Anurag Windlass Gupta , Stefano Stefani , Aleksandras Surna
- Applicant: Amazon Technologies, Inc.
- Applicant Address: US WA Seattle
- Assignee: Amazon Technologies, Inc.
- Current Assignee: Amazon Technologies, Inc.
- Current Assignee Address: US WA Seattle
- Agency: Meyertons, Hood, Kivlin, Kowert & Goetzel, P.C.
- Agent Robert C. Kowert
- Main IPC: G06F16/24
- IPC: G06F16/24 ; G06F16/2453 ; G06F17/30 ; G06F16/28

Abstract:
A query optimizer may receive a query (e.g., from a source that generated the query). Input that specifies both a query hint string and a hint may be received to a hint specification interface. The hint may be applied to the query, from outside the query, to optimize a query execution plan. Applying the hint may be based, at least in part, on a query hint string. For example, which query block is associated with the query hint string may be determined. Upon such a determination, the hint may be applied to the determined query block.
Public/Granted literature
- US20160253385A1 GLOBAL QUERY HINT SPECIFICATION Public/Granted day:2016-09-01
Information query