公开(公告)号：US20190236188A1

公开(公告)日：2019-08-01

申请号：US15885559

申请日：2018-01-31

Applicant: salesforce.com, inc.

Inventor： William J. McKenna

IPC: G06F17/30

CPC classification number: G06F16/24544 ,  G06F16/2453 ,  G06F16/24565

Abstract: Techniques are disclosed relating to database query optimizers. In some embodiments, a query optimizer of a database system receives a first query including a first constraint that restricts selection of a set of execution plans available to implement the first query. The first constraint identifies, at least, a first option and a second option to implement a clause in the first query. The query optimizer evaluates, based on the first constraint, a first execution plan that includes performance of the first option and a second execution plan that includes performance of the second option. Based on the evaluating, the query optimizer selects one of the first and second execution plans to implement the first query. The query optimizer causes execution of the selected execution plan.

公开(公告)号：US11934397B2

公开(公告)日：2024-03-19

申请号：US16778938

申请日：2020-01-31

Applicant: salesforce.com, inc.

Inventor： Rama Krishna Korlapati ,  William J. McKenna ,  John Francis O'Brien

IPC: G06F16/2453 ,  G06F11/34 ,  G06F16/2452

CPC classification number: G06F16/24544 ,  G06F11/3409 ,  G06F16/24526

Abstract: Techniques are disclosed relating to database query optimizers. In some embodiments, a query parser of a database system receives a query requesting data from a multi-tenant database. The query includes a first constraint that restricts a query optimizer's selection of a set of execution plans available to implement the query. The database system determines whether an override has been specified for a particular tenant associated with the received query, the override indicating that the first constraint is to be replaced with a second constraint for the particular tenant. In response to determining that the override has been specified for the particular tenant, the database system replaces the first constraint in the query with the second constraint and provides the query with the second constraint to the query optimizer for selection of an execution plan in accordance with the second constraint.

公开(公告)号：US20210240710A1

公开(公告)日：2021-08-05

申请号：US16778938

申请日：2020-01-31

Applicant: salesforce.com, inc.

Inventor： Rama Krishna Korlapati ,  William J. McKenna ,  John Francis O'Brien

IPC: G06F16/2453 ,  G06F11/34 ,  G06F16/2452

Abstract: Techniques are disclosed relating to database query optimizers. In some embodiments, a query parser of a database system receives a query requesting data from a multi-tenant database. The query includes a first constraint that restricts a query optimizer's selection of a set of execution plans available to implement the query. The database system determines whether an override has been specified for a particular tenant associated with the received query, the override indicating that the first constraint is to be replaced with a second constraint for the particular tenant. In response to determining that the override has been specified for the particular tenant, the database system replaces the first constraint in the query with the second constraint and provides the query with the second constraint to the query optimizer for selection of an execution plan in accordance with the second constraint.