Chapter 8Performance
THE SNOWPRO CORE EXAM TOPICS COVERED IN THIS CHAPTER INCLUDE THE FOLLOWING:
Snowflake includes several optimization features, such as the metadata cache, the query result cache, the virtual warehouse cache, and partition pruning, that Snowflake automatically uses to optimize performance. Snowflake also provides additional performance capabilities that can be manually configured to improve performance. These capabilities include scaling up and down a virtual warehouse or autoscaling a virtual warehouse to accommodate increased concurrency. This chapter focuses on the performance optimization features and techniques that you can use to improve query performance and, at times, reduce costs.
Snowflake ...
Get Snowflake SnowPro Core Certification Study Guide 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.
