COF-C02 · Question #612
Which query types will have significant performance improvement when run using the search optimization service? (Select TWO)
The correct answer is A. Range searches B. Equality searches. The Snowflake Search Optimization Service is specifically designed to accelerate point lookup and selective predicate queries. Equality searches (e.g., WHERE col = 'value') and range searches (e.g., WHERE col BETWEEN x AND y) benefit significantly because search access paths…
Question
Which query types will have significant performance improvement when run using the search optimization service? (Select TWO)
Options
- ARange searches
- BEquality searches
- CSubstring searches
- DQueries with IN predicates
- EQueries with aggregation
How the community answered
(19 responses)- A89% (17)
- C5% (1)
- D5% (1)
Explanation
The Snowflake Search Optimization Service is specifically designed to accelerate point lookup and selective predicate queries. Equality searches (e.g., WHERE col = 'value') and range searches (e.g., WHERE col BETWEEN x AND y) benefit significantly because search access paths allow Snowflake to skip irrelevant micro-partitions without a full table scan. Queries with aggregation (E) rely on compute, not selective pruning, and benefit more from larger warehouses. Substring searches (C) require specific SUBSTRING_MATCH support. Queries with IN predicates (D) can benefit but are not listed as the primary top improvements in this question's context.
Topics
Community Discussion
No community discussion yet for this question.