Snowflake SnowPro Core
Get started today
Ultimate access to all questions.
Comments
Loading comments...
Ultimate access to all questions.
How does the search optimization service improve query performance for Snowflake users?
A
It scans the micro-partitions based on the joins used in the queries and scans only join columns.
B
It maintains a persistent data structure that keeps track of the values of the table’s columns in each of its micro-partitions.
C
It scans the local disk cache to avoid scans on the tables used in the query.
D
It keeps track of running queries and their results and saves those extra scans on the table.