Optimizing performance in Snowflake¶

The following topics help guide efforts to improve the performance of Snowflake.

Gain insights into the historical performance of queries using the web interface or by writing queries against data in the ACCOUNT_USAGE schema.

Optimizing query performance

Learn about options for optimizing Snowflake query performance.

Optimizing warehouses for performance

Learn about strategies to fine-tune computing power in order to improve the performance of a query or set of queries running on a warehouse, including enabling the Query Acceleration Service.

Optimizing storage for performance

Learn how storing similar data together, creating optimized data structures, and defining specialized data sets can improve the performance of queries.

Helpful when choosing between Automatic Clustering, Search Optimization Service, and materialized views.

Analyzing query workloads with Performance Explorer

Learn how to use Performance Explorer in Snowsight to monitor interactive metrics for SQL workloads.

Snowflake Optima

Learn how Snowflake Optima continuously analyzes workload patterns and implements the most effective strategies automatically.