Ultimate access to all questions.
Upgrade Now 🚀
Sign in to unlock AI tutor
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.
