QuestionQ100

Performance Optimization, Querying & Transformation

Which feature or service optimizes point lookups on large tables with high-cardinality columns?

Explanation

Snowflake Search Optimization Service is designed for highly selective point-lookup queries on large tables. Its search access path identifies the micro-partitions that can contain a requested value, reducing unnecessary scans; this is particularly useful when the lookup column has many distinct values.

Learn more

Community Discussion

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