SnowPro Advanced Architect

By Snowflake · Question Mode

QuestionQ10

Performance, Cost, and Resource Optimization

What is an important consideration when configuring the search optimization service for a table?

Explanation

Search optimization is most effective for selective filters on a column with roughly 100,000 or more distinct values. External tables are unsupported, and clustering or GZIP compression is not a requirement of the service.

Learn more

Community Discussion

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