- 专利标题: Estimated execution time for query execution
-
申请号: US18051185申请日: 2022-10-31
-
公开(公告)号: US11687531B2公开(公告)日: 2023-06-27
- 发明人: Sangyong Hwang , Sourav Sikdar , Li Yan
- 申请人: Snowflake Inc.
- 申请人地址: US MT Bozeman
- 专利权人: Snowflake Inc.
- 当前专利权人: Snowflake Inc.
- 当前专利权人地址: US MT Bozeman
- 代理机构: Schwegman Lundberg & Woessner, P.A.
- 主分类号: G06F16/245
- IPC分类号: G06F16/245 ; G06F16/2453 ; G06F16/2455 ; G06F11/34
摘要:
The subject technology tracks a plurality of queries corresponding to a plurality of query plans based on join operations contained in each of the plurality of queries and a previous time of executing each query. The subject technology selects a first query plan among the plurality of query plans. 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 a previous query plan. The subject technology attempts to execute a first query using the first query plan. The subject technology determines that a second query plan selected among the plurality of query plans has a second estimated execution time that is less than an estimated execution time of the first query plan. The subject technology executes the first query corresponding to the first query plan at a subsequent time using the second query plan.
公开/授权文献
- US20230067482A1 ESTIMATED EXECUTION TIME FOR QUERY EXECUTION 公开/授权日:2023-03-02
信息查询