What type of query benefits the MOST from search optimization?
A.
A query that uses only disjunction (i.e., OR) predicates
B.
A query that includes analytical expressions
C.
A query that uses equality predicates or predicates that use IN
D.
A query that filters on semi-structured data types
The Answer Is:
C
This question includes an explanation.
Explanation:
Search optimization in Snowflake is designed to improve the performance of queries that are selective and involve point lookup operations using equality and IN predicates. It isparticularly beneficial for queries that access columns with a high number of distinct values1.