Can search optimization indirectly improve the performance of views that rely on a base table with a selective predicate?

• A. Yes
• B. No
• C. Only for secure views
• D. Only for materialized views

Answer: (A)

Search Optimization Service speeds access to large tables by building an auxiliary structure that helps prune data for selective predicates. When a view reads a base table and applies a filter, Snowflake can use that SOS structure to skip non-matching data blocks before producing the view’s results. Since the view’s results come from querying the base table, any faster data access at the base table level naturally improves the view’s performance. This applies regardless of the view type, so the benefit isn’t limited to secure or materialized views. However, the improvement depends on the predicate’s selectivity and the SOS configuration, so not every query will see a speedup.