Optimizing performance in Snowflake

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

Exploring execution times

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

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.