SnowPro Core RecertificationRetired

By Snowflake · Question Mode

QuestionQ21

VerifiedData Engineering

Which persistent data structure does the search optimization service use to enhance point-lookup performance?

Explanation

The Search Optimization Service creates and maintains search access paths, persistent structures that track which column values might exist in each micro-partition so unnecessary micro-partitions can be skipped during selective lookups.

Learn more

Community Discussion

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