COF-C02 · Question #608
What persistent data structures are used by the search optimization service to improve the performance of point lookups?
The correct answer is D. Search access paths. The Snowflake Search Optimization Service builds and maintains persistent data structures called search access paths. These are stored alongside the table data and allow Snowflake to quickly locate micro-partitions that are likely to contain matching rows for point lookup and…
Question
What persistent data structures are used by the search optimization service to improve the performance of point lookups?
Options
- AMicro-partitions
- BClustering keys
- CEquality searches
- DSearch access paths
How the community answered
(31 responses)- A3% (1)
- B3% (1)
- D94% (29)
Explanation
The Snowflake Search Optimization Service builds and maintains persistent data structures called search access paths. These are stored alongside the table data and allow Snowflake to quickly locate micro-partitions that are likely to contain matching rows for point lookup and equality queries, without scanning all micro-partitions. Micro-partitions are the underlying storage units Snowflake uses, and clustering keys help with range-based pruning, but search access paths are the specific structures created by the search optimization service.
Topics
Community Discussion
No community discussion yet for this question.