Which query types will have significant performance improvement when run using the search optimization service? (Choose two.)
Which query types will have significant performance improvement when run using the search optimization service? (Choose two.)
B and D
agree, its B& D
https://docs.snowflake.com/en/user-guide/search-optimization/point-lookup-queries
Selected Answer: BC Search Optimization Service •Equality searches. •Substring and regular expression searches. •Character data (text) and IPv4 address searches. •Searches of fields in VARIANT. •Searches of GEOGRAPHY columns using geospatial functions. https://docs.snowflake.com/en/user-guide/search-optimization-service
B and D is correct
BD seems logic since they are both kinds of equality searches
Point lookup queries are queries that are expected to return a small number of rows. The search optimization service can improve the performance of point lookup queries that use: Equality predicates (for example, <column_name> = <constant>). Predicates that use IN (see example). Example