COF-C03 - Performance Optimization, Querying, and Transformation - Section 4.3

Optimise performance with clustering keys, materialized views, the search optimization service, and the query acceleration service.

Apply the advanced optimisation features and know when each pays off: a clustering key with automatic clustering on a very large table with selective filters, materialized views for repeated expensive aggregations, the search optimization service for selective point lookups, and the query acceleration service for queries with large scans or unpredictable bursts. Recognise the cost trade-off of each.

Examworthy is not affiliated with or endorsed by Snowflake. Original, blueprint-aligned practice material only.