An Architect is evaluating the compute and storage costs of a storage strategy to enhance performance techniques.
Which performance optimization techniques in Snowflake have associated storage costs?
Materialized views store precomputed results, and the Search Optimization Service stores an additional search-access-path structure. Clustering a table can also incur storage costs when reclustering rewrites micro-partitions and increases Fail-safe storage. Snowflake identifies all three as performance optimizations with storage costs.
Community Discussion