公开(公告)号：US20250045277A1

公开(公告)日：2025-02-06

申请号：US18656062

申请日：2024-05-06

Applicant: Snowflake Inc.

Inventor： Sangyong Hwang ,  Adem Khachnaoui ,  Li Yan ,  Yongsik Yoon

IPC: G06F16/2453 ,  G06F11/34 ,  G06F16/22

Abstract: A query engine can use partition-granular level statistics to optimize query performance. A query can reference a table with a plurality of partitions and include a predicate. A partition-granular selectivity estimate for the predicate can be generated based on statistics stored regarding the plurality of partitions of the table. A query plan can be generated based on partition-granular selectivity estimate to optimize query processing.

公开(公告)号：US12007994B1

公开(公告)日：2024-06-11

申请号：US18362369

申请日：2023-07-31

Applicant: Snowflake Inc.

Inventor： Sangyong Hwang ,  Adem Khachnaoui ,  Li Yan ,  Yongsik Yoon

IPC: G06F16/22 ,  G06F11/34 ,  G06F16/2453

CPC classification number: G06F16/24544 ,  G06F11/3452 ,  G06F16/2282

Abstract: A query engine can use partition-granular level statistics to optimize query performance. A query can reference a table with a plurality of partitions and include a predicate. A partition-granular selectivity estimate for the predicate can be generated based on statistics stored regarding the plurality of partitions of the table. A query plan can be generated based on partition-granular selectivity estimate to optimize query processing.