公开(公告)号：US20180218040A1

公开(公告)日：2018-08-02

申请号：US15419509

申请日：2017-01-30

Applicant: salesforce.com, inc.

Inventor： RamaLinga Raju PENMETSA ,  Prem VEERAMANI ,  Jeffrey Lallana FRESCHL ,  Jesse COLLINS ,  Ganesh MAGANTI

IPC: G06F17/30

CPC classification number: G06F16/24542 ,  G06F16/24547

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.