The search optimization service can improve the performance of queries with the following types of join predicates:
i> Equality predicates of the form dimension_table.column = fact_table.column.
ii> Transformations on the side of the predicate with the dimension (e.g. string concatenation, addition, etc.).
iii> Conjunctions (AND) of multiple equality predicates.
https://medium.com/snowflake/snowflake-performance-search-optimization-service-part-2-382714956588
D correct.
Search optimization can improve the performance of these types of queries:
1)Equality or IN Predicates
2)Substrings and Regular Expressions (LIKE/ILIKE/RLIKE/CONTAINS,... )
3)Fields in VARIANT Columns
4)Geospatial Functions
5)Conjunctions of Supported Predicates (AND)
6)Disjunctions of Supported Predicates (OR)
-----------------------------------------------------------------------------------
The search optimization service does not directly improve the performance of joins.
https://docs.snowflake.com/en/user-guide/search-optimization-service#label-search-optimization-service-queries
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
nexerSnow
10 months agoBobFar
1 year, 2 months agoHeetec
1 year, 2 months ago