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 ...