© The Author(s), under exclusive license to APress Media, LLC, part of Springer Nature 2022
A. MortonMastering Snowflake Solutionshttps://doi.org/10.1007/978-1-4842-8029-4_9

9. Advanced Performance Tuning

Adam Morton1  
(1)
Sydney, NSW, Australia
 

How do you tune the Snowflake data warehouse when there are no indexes and limited options available to tune the database itself?

Snowflake was designed for simplicity, to reduce administrative overhead, and to work straight out of the box. It keeps its promise pretty well in my experience, but at some stage your data volumes and user base may well reach a tipping point where you need to get your hands dirty.

Out of the box, you can increase the virtual warehouse size to improve performance. If you want a more ...

Get Mastering Snowflake Solutions: Supporting Analytics and Data Sharing now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.