公开(公告)号：US11176138B2

公开(公告)日：2021-11-16

申请号：US16800837

申请日：2020-02-25

Applicant: salesforce.com, inc.

Inventor： Punit B. Shah ,  Douglas Doole ,  Rama K Korlapati ,  Serge P. Rielau

IPC: G06F16/245 ,  G06F16/2453

Abstract: Caching runtime plan data that is determined not to change for different invocations of a query plan. In some embodiments, a computing system accesses information that specifies a query plan generated for a first database query and generates a first runtime plan for the first database query based on the query plan. In some embodiments, the system caches information generated for the first runtime plan that is determined not to change for different invocations of the query plan. For example, transformation code may include separate functions for mutable and immutable state. In some embodiments, the system retrieves and uses the cached information to generate a second runtime plan for a second database query. Disclosed techniques may improve performance of query plan transformations that hit in the runtime plan cache.

公开(公告)号：US20210263936A1

公开(公告)日：2021-08-26

申请号：US16800837

申请日：2020-02-25

Applicant: salesforce.com, inc.

Inventor： Punit B. Shah ,  Douglas Doole ,  Rama K. Korlapati ,  Serge P. Rielau

IPC: G06F16/2453

Abstract: Caching runtime plan data that is determined not to change for different invocations of a query plan. In some embodiments, a computing system accesses information that specifies a query plan generated for a first database query and generates a first runtime plan for the first database query based on the query plan. In some embodiments, the system caches information generated for the first runtime plan that is determined not to change for different invocations of the query plan. For example, transformation code may include separate functions for mutable and immutable state. In some embodiments, the system retrieves and uses the cached information to generate a second runtime plan for a second database query. Disclosed techniques may improve performance of query plan transformations that hit in the runtime plan cache.