COF-C03 - Performance Optimization, Querying, and Transformation - Section 4.4
Improve query performance by sizing virtual warehouses, scaling up versus out, and managing concurrency and queuing.
Decide how to use compute for performance: scale up to a larger warehouse for a single complex query and scale out with a multi-cluster warehouse for many concurrent queries. Manage concurrency, query queuing, and the statement timeout, and recognise why a larger warehouse is not always the answer to a slow query.
scale up versus scale outwarehouse sizingconcurrency and queuingmulti-cluster scalingstatement timeout
More in this domain
Back to all Performance Optimization, Querying, and Transformation objectives, or the COF-C03 cert hub.
Examworthy is not affiliated with or endorsed by Snowflake. Original, blueprint-aligned practice material only.