What is a key consideration when setting up search optimization service for a table?
What is a key consideration when setting up search optimization service for a table?
Search optimization service works best with a column that has a minimum of 100,000 distinct values. This is because the optimization relies on the ability to quickly filter and index data, which is more effective when dealing with a large number of distinct values. This helps improve query performance by allowing faster access to the relevant subset of data.
Correct Answer should be A "At least one of the columns accessed by the query filter operation has on the order of 100,000 distinct values or more." https://docs.snowflake.com/en/user-guide/search-optimization/queries-that-benefit
Correct Answer is A