公开(公告)号：US20170147639A1

公开(公告)日：2017-05-25

申请号：US14946745

申请日：2015-11-19

Applicant: SAP SE

Inventor： Jane Jung Lee ,  Taehyung Lee ,  Jiyoung Yoo ,  Sung Heun Wi ,  Ki Hong Kim

IPC: G06F17/30

CPC classification number: G06F17/30463

Abstract: In one aspect there is a method. The method may include associating a query received from an application with a hint, wherein the hint modifies an execution of the query. The method may further include an optimizer to compile the query according to the hint to produce a second query plan. When no hint is associated with the query, the optimizer may produce a first query plan. The method may further include storing the hint in a persistent table to enable state preservation during a database restart or binary upgrade, and/or executing the query using the second query plan.

公开(公告)号：US10303686B2

公开(公告)日：2019-05-28

申请号：US14946745

申请日：2015-11-19

Applicant: SAP SE

Inventor： Jane Jung Lee ,  Taehyung Lee ,  Jiyoung Yoo ,  Sung Heun Wi ,  Ki Hong Kim

IPC: G06F16/00 ,  G06F16/2453 ,  G06F17/30

Abstract: In one aspect there is a method. The method may include associating a query received from an application with a hint, wherein the hint modifies an execution of the query. The method may further include an optimizer to compile the query according to the hint to produce a second query plan. When no hint is associated with the query, the optimizer may produce a first query plan. The method may further include storing the hint in a persistent table to enable state preservation during a database restart or binary upgrade, and/or executing the query using the second query plan.