Invention Grant
- Patent Title: Dynamic query execution using estimated execution time
-
Application No.: US17657468Application Date: 2022-03-31
-
Publication No.: US11544263B2Publication Date: 2023-01-03
- Inventor: Sangyong Hwang , Sourav Sikdar , Li Yan
- Applicant: Snowflake Inc.
- Applicant Address: US MT Bozeman
- Assignee: Snowflake Inc.
- Current Assignee: Snowflake Inc.
- Current Assignee Address: US MT Bozeman
- Agency: Schwegman Lundberg & Woessner, P.A.
- Main IPC: G06F16/245
- IPC: G06F16/245 ; G06F16/2453 ; G06F11/34 ; G06F16/2455

Abstract:
The subject technology receives a first query plan corresponding to a first query, the first query plan comprising a new query plan different than a previous query plan for the first query. The subject technology determines a value indicating an estimated improvement in execution time of the first query plan in comparison to a previous execution time of the previous query plan. The subject technology, in response to determining that the value is greater than a threshold value, attempting to execute the first query using the first query plan, the attempting comprising determining that a second query plan selected among a plurality of query plans has a second estimated execution time that is less than an estimated execution time of the first query plan, and executing the first query at a subsequent time using the second query plan.
Public/Granted literature
- US20220245148A1 DYNAMIC QUERY EXECUTION USING ESTIMATED EXECUTION TIME Public/Granted day:2022-08-04
Information query