# Missing or inefficient use of materialized views Canonical: https://www.pointfive.co/efficiency-hub/inefficiencies/missing-or-inefficient-use-of-materialized-views Inefficiency arises when MVs are either underused or misused. When high-cost, repetitive queries are not backed by MVs, workloads consume unnecessary... By: Simar Arora Updated: 2026-09-28 [Cloud Efficiency Hub](https://www.pointfive.co/efficiency-hub) # Missing or Inefficient Use of Materialized Views [Simar Arora](https://www.linkedin.com/in/simarpreet-arora/) Value Engineer - FinOps @ Snowflake Snowflake service [Snowflake Materialized Views](https://www.pointfive.co/efficiency-hub/cloud-services/snowflake-materialized-views) Category [Other](https://www.pointfive.co/efficiency-hub/service-category/other) Reference CER-0026 Type Inefficient Architecture ## Explanation Why the waste happens and who it affects. Inefficiency arises when MVs are either underused or misused. - When high-cost, repetitive queries are not backed by MVs, workloads consume unnecessary compute resources. - When MVs exist but are rarely queried, their background refresh and storage costs accumulate without offsetting savings. Proper evaluation of workload patterns and strategic use of MVs is critical to achieve a net cost benefit. ## Billing model The pricing dimensions that drive this cost. - Storage - each materialized view stores its query results, which adds to the account's monthly storage usage - Maintenance compute - when the base table changes, a Snowflake-managed background service updates every materialized view defined on it, billed as serverless credits in 1-second increments (the rate is listed in the Serverless Feature Credit Table of the Snowflake Service Consumption Table) - Maintenance cost grows with the number of materialized views per base table, the amount of data that changes, and whether the views are clustered; suspending maintenance usually only defers these costs ## How to detect 4 checks to find it in your estate. - Analyze query history to identify expensive, frequently executed queries that could benefit from materialization. - Review existing MVs for read activity to detect underutilized or idle materialized views. - Compare MV refresh costs and storage footprint against active query savings to assess net cost effectiveness. - Validate whether candidate workloads involve relatively stable datasets appropriate for materialization. ## How to fix 5 ways to remove the waste. - Create materialized views for high-cost, repetitive queries where refresh costs are low relative to compute savings. - Check eligibility first: Snowflake materialized views require Enterprise Edition and can query only a single table (no joins, window functions, or UDFs), so for expensive repeated queries with joins or complex logic consider alternatives such as dynamic tables - Decommission materialized views that incur maintenance and storage costs without sufficient query usage. - Implement periodic reviews of MV usage and refresh behavior as data volumes and access patterns evolve. - Engage data engineering teams to tune MV designs for optimal cost-benefit balance (e.g., selective columns, filtered subsets). ## Documentation Vendor references for pricing and configuration. - [Working with Materialized Views docs.snowflake.com](https://docs.snowflake.com/en/user-guide/views-materialized) - [MATERIALIZED\_VIEW\_REFRESH\_HISTORY docs.snowflake.com](https://docs.snowflake.com/en/sql-reference/functions/materialized_view_refresh_history) - [Understanding compute cost docs.snowflake.com](https://docs.snowflake.com/en/user-guide/cost-understanding-compute) - [Dynamic tables docs.snowflake.com](https://docs.snowflake.com/en/user-guide/dynamic-tables/overview) ## Related inefficiencies [Browse the library](https://www.pointfive.co/efficiency-hub) - Snowflake Tasks and Pipelines CER-0025 ### [Inefficient Pipeline Refresh Scheduling](https://www.pointfive.co/efficiency-hub/inefficiencies/inefficient-pipeline-refresh-scheduling) Inefficient pipeline refresh scheduling occurs when data refresh operations are executed more frequently, or with more compute resources, than the actual downstream business usage requires. Without aligning refresh frequency and resource... Other - Snowflake Query Processing CER-0029 ### [Suboptimal Query Routing](https://www.pointfive.co/efficiency-hub/inefficiencies/suboptimal-query-routing) Organizations may experience unnecessary Snowflake spend due to inefficient query-to-warehouse routing, lack of dynamic warehouse scaling, or failure to consolidate workloads during low-usage periods. Snowflake now offers Adaptive... Other - Snowflake Search Optimization Service CER-0131 ### [Suboptimal Use of Search Optimization Service](https://www.pointfive.co/efficiency-hub/inefficiencies/suboptimal-use-of-search-optimization-service) Search Optimization can enable significant cost savings when selectively applied to workloads that heavily rely on point-lookup queries. By improving lookup efficiency, it allows smaller warehouses to satisfy performance SLAs, reducing... Other --- Source: the public page above. Product screenshots and illustrative interfaces are examples, not live customer data.