Salesforce, Inc.

RamaLinga Raju Penmetsa

Jesse Yarbro Collins

Prem Veeramani

Ganesh Maganti

Jeffrey Lallana Freschl

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.

Growing community of inventors

Rancho Cordova, CA, United States of America

RamaLinga Raju Penmetsa