SnowPro Advanced Architect

By Snowflake · Question Mode

QuestionQ71

Performance, Cost, and Resource Optimization

An Architect observes poor query performance on a large table. The Query Profile indicates that multiple teams in the company access the table. Each team retrieves particular data subsets through point-lookup queries on different columns.

What can be done to ensure performant queries for all teams?

Explanation

Snowflake Search Optimization Service accelerates highly selective point-lookup queries, including equality and IN predicates, by using a persistent search access structure. It can be enabled for an entire underlying table or particular columns, making it suitable when different teams perform selective lookups on different columns. A clustering key is limited to one key and is generally less suitable for disparate point-lookup columns.

Learn more

Community Discussion

No comments yet. Be the first to start the discussion!