How does the search optimization service help Snowflake users improve query performance?

Question

Nosh Shah · Accepted Answer

II maintains a persistent data structure that keeps track of the values of the table's columns m each of its micro-partitions.

Nosh Shah · Answer

It scans the micro-partitions based on the joins used in the queries and scans only join columns.

Nosh Shah · Answer

It scans the local disk cache to avoid scans on the tables used in the Query.

Nosh Shah · Answer

It keeps track of running queries and their results and saves those extra scans on the table.

List of questions