公开(公告)号：US20250103572A1

公开(公告)日：2025-03-27

申请号：US18472819

申请日：2023-09-22

Applicant: Snowflake Inc.

Inventor： Matthew C. Loring ,  Dimitrios Tsirogiannis

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

Abstract: The subject technology receives a query. The subject technology performs a secondary index scan operation of a secondary index based on the query. The subject technology determines that a number of rows returned, from the secondary index scan operation, meets a threshold value. The subject technology sends a signal to a primary index probe operation to initiate a blob storage scan using at least one range scan operation. The subject technology extracts a primary key of each row from the rows returned from the secondary index scan operation. The subject technology identifies a corresponding range of each extracted primary key in the blob storage. The subject technology scans each corresponding range of the blob storage to identify a set of rows that satisfy a set of predicates on an index column. The subject technology provides a set of rows as a result of the query.