CODEWITHSUNDEEP
sqlquery-optimizationsnowflake-cloud-data-platform
Chicken Sandwich No Pickles
Chicken Sandwich No Pickles

Reputation: 3362

Snowflake Query Performance Improvement

I just started working with the Snowflake database.

Snowflake does not allow for Indexes to be created, that being said, what are some ways I can speed up my SQL query performance?

In the past, I would create #temp tables and throw some indexes on, but this is not possible.

Any suggestions?

Upvotes: 2

Views: 5449

Answers (1)

Gokhan Atil
Gokhan Atil

Reputation: 10154

Creating temp tables, materialized views are common approaches to improve queries. If you want to improve the performance of point lookup queries, please check SOS:

https://docs.snowflake.com/en/user-guide/search-optimization-service.html

If you want to improve data warehouse style queries, check clustering keys and auto-clustering:

https://docs.snowflake.com/en/user-guide/tables-clustering-keys.html

I also recommend you to check the following post:

https://dzone.com/articles/snowflake-performance-tuning-top-5-best-practices

Upvotes: 3

Related Questions