Optimized validation of cached query plans

    公开(公告)号:US12277117B1

    公开(公告)日:2025-04-15

    申请号:US18649537

    申请日:2024-04-29

    Applicant: Snowflake Inc.

    Abstract: The subject technology receives a query, the query including a statement for performing the query. The subject technology performs a lookup operation on a stored plan cache based on the query. The subject technology performs, in response to a cache match of the query to a stored query plan in the stored plan cache based on the lookup operation, a validation process of the stored query plan. The subject technology determines whether the stored query plan is valid based on the validation process. The subject technology performs, in response to determining that the stored query plan is valid, a program building process for the stored query plan to generate a final query plan. The subject technology sends the final query plan to an execution node for execution.

Patent Agency Ranking