公开(公告)号：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.