公开(公告)号：US11436223B2

公开(公告)日：2022-09-06

申请号：US15419509

申请日：2017-01-30

Applicant: salesforce.com, inc.

Inventor： RamaLinga Raju Penmetsa ,  Prem Veeramani ,  Jeffrey Lallana Freschl ,  Jesse Collins ,  Ganesh Maganti

IPC: G06F16/2453

Abstract: Systems, methods, and computer-readable media for pinning query execution plans are described. A database system may obtain a query, and determine a organization identifier and/or user identifier associated with the query. The database system may identify an optimized plan among a set of query plans that correspond with the query, and may generate a query execution plan based on the query and the optimized plan. The database system may determine a pinned plan that is associated with the optimized plan, and may generate a query execution plan based on the pinned plan when the pinned plan is associated with the optimized plan and corresponds with the organization identifier and/or the user identifier. The database system may generate a query execution plan using optimization functions when the pinned plan is not associated with the pinned plan, or the organization identifier and/or the user identifier. Other embodiments may be described and/or claimed.