Invention Grant
- Patent Title: Query plan overrides
-
Application No.: US16778938Application Date: 2020-01-31
-
Publication No.: US11934397B2Publication Date: 2024-03-19
- Inventor: Rama Krishna Korlapati , William J. McKenna , John Francis O'Brien
- Applicant: salesforce.com, inc.
- Applicant Address: US CA San Francisco
- Assignee: Salesforce, Inc.
- Current Assignee: Salesforce, Inc.
- Current Assignee Address: US CA San Francisco
- Agency: Kowert, Hood, Munyon, Rankin & Goetzel, P.C.
- Agent Paul T. Seegers; Dean M. Munyon
- Main IPC: G06F16/2453
- 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.
Public/Granted literature
- US20210240710A1 QUERY PLAN OVERRIDES Public/Granted day:2021-08-05
Information query