COF-C02 · Question #443
Which use case does the search optimization service support?
The correct answer is D. Conjunctions (AND) of multiple equality predicates. The search optimization service is designed to accelerate selective point-lookup queries - specifically those that use equality predicates (=) combined with AND conjunctions. It builds a persistent search access path structure that allows Snowflake to quickly identify matching…
Question
Which use case does the search optimization service support?
Options
- ADisjuncts (OR) in join predicates
- BLIKE/ILIKE/RLIKE join predicates
- CJoin predicates on VARIANT columns
- DConjunctions (AND) of multiple equality predicates
How the community answered
(67 responses)- A1% (1)
- B3% (2)
- C7% (5)
- D88% (59)
Explanation
The search optimization service is designed to accelerate selective point-lookup queries - specifically those that use equality predicates (=) combined with AND conjunctions. It builds a persistent search access path structure that allows Snowflake to quickly identify matching micro-partitions without full scans. It does NOT support: OR/disjunct predicates in join conditions (A), LIKE, ILIKE, or RLIKE pattern matching in join predicates (B), or VARIANT column join predicates (C). Those patterns require different optimization approaches.
Topics
Community Discussion
No community discussion yet for this question.