A materialized view stores precomputed results and is useful when a query is repeated and the underlying table does not change often. Since the query runs calculations on a stable table, materializing the result can reduce repeated computation.
Reference: Snowflake Documentation - Materialized views; Query optimization.
==

In a Snowflake Query Profile, the statistics " Partitions scanned " and " Bytes scanned " reflect the efficiency of query pruning. Query pruning refers to the ability of the query engine to skip unnecessary data, thereby reducing the amount of data that needs to be processed. Efficient pruning results in fewer partitions and bytes being scanned, improving query performance.
Snowflake Documentation: Understanding Query Profiles
Top of Form
Bottom of Form

The default value for auto-suspending a Virtual Warehouse in the Snowflake Web Interface (UI) is 10 minutes. This setting helps manage compute costs by automatically suspending warehouses that are not in use, ensuring that compute resources are efficiently allocated and not wasted on idle warehouses.
References:
Snowflake Documentation: Virtual Warehouses