QuestionQ13Verified/Performance, Cost, and Resource OptimizationCopy linkReport a problemAsk AstroTutorSave questionWhich performance-optimization techniques can affect storage costs?Choose twoARewriting a queryBUsing the search optimization serviceCCreating a multi-cluster virtual warehouseDEnabling Automatic ClusteringEIncreasing the MIN_CLUSTER_COUNT in a multi-cluster virtual warehouseShow AnswerAnswerExplanationThe Search Optimization Service stores an additional search access path for enabled tables. Automatic Clustering can also increase Fail-safe storage when reclustering rewrites existing micro-partitions. Multi-cluster virtual warehouse configuration affects compute resources, not storage. Snowflake performance optimization documentationLearn moreSnowflake: Optimizing query performanceSnowflake: Automatic ClusteringShow comments0Show commentsCommunity DiscussionNo comments yet. Be the first to start the discussion!
Community Discussion