# Inefficient execution of repeated queries | Cloud Efficiency Hub Canonical: https://www.pointfive.co/efficiency-hub/inefficiencies/inefficient-execution-of-repeated-queries Inefficient execution of repeated queries occurs when common query patterns are frequently executed without optimization. By: Simar Arora Updated: 2026-09-28 [Cloud Efficiency Hub](https://www.pointfive.co/efficiency-hub) # Inefficient Execution of Repeated Queries The short version Inefficient execution of repeated queries occurs when common query patterns are frequently executed without optimization. [Simar Arora](https://www.linkedin.com/in/simarpreet-arora/) Value Engineer - FinOps @ Snowflake Snowflake service [Snowflake Query Processing](https://www.pointfive.co/efficiency-hub/cloud-services/snowflake-query-processing) Category [Compute](https://www.pointfive.co/efficiency-hub/service-category/compute) Reference CER-0112 Type Inefficient Architecture ## Explanation Why the waste happens and who it affects. Even if individual executions are successful, repeated inefficiencies compound overall compute consumption and credit costs. By analyzing Snowflake's parameterized query metrics, organizations can identify top repeated queries and optimize them for better performance, resource usage, and cost-efficiency. ## Billing model The pricing dimensions that drive this cost. - Queries run on virtual warehouses, which consume credits based on warehouse size and how long the warehouse runs; each size step up roughly doubles the credits billed per hour - Warehouse credits are billed per second with a 60-second minimum each time a warehouse starts or resumes, and a suspended warehouse consumes no credits - Cloud services usage is charged only when daily cloud services consumption exceeds 10% of daily warehouse usage - The QUERY\_ATTRIBUTION\_HISTORY view attributes warehouse credits to individual queries (excluding warehouse idle time), and can be grouped by QUERY\_PARAMETERIZED\_HASH to total the cost of a repeated query pattern ## How to detect 4 checks to find it in your estate. - Review parameterized query groupings to identify the most frequently executed query patterns - Analyze whether repeated queries are incurring high cumulative warehouse costs or extended runtimes - Evaluate if frequent errors are occurring in repeated query executions, indicating underlying inefficiencies - Consult with data engineering teams to assess whether query logic, data access patterns, or clustering keys and Search Optimization can be improved ## How to fix 5 ways to remove the waste. - Prioritize optimization efforts on the highest-cost or highest-frequency repeated queries - Refactor query structures to minimize unnecessary complexity, joins, or large data scans - Tune data models, clustering keys, or materialized views to support more efficient repeated query execution - Apply query scheduling or caching techniques where possible to reduce redundant executions - Monitor parameterized query patterns regularly to identify and address emerging inefficiencies ## Documentation Vendor references for pricing and configuration. - [Query Cost Attribution docs.snowflake.com](https://docs.snowflake.com/en/sql-reference/account-usage/query_attribution_history) - [Query History docs.snowflake.com](https://docs.snowflake.com/en/sql-reference/functions/query_history) - [Using the Query Hash to Identify Patterns and Trends in Queries docs.snowflake.com](https://docs.snowflake.com/en/user-guide/query-hash) ## Related inefficiencies [Browse the library](https://www.pointfive.co/efficiency-hub) - Snowflake Query Processing CER-0515 ### [Excessive Snowflake Cloud Services Consumption from Metadata-Heavy Operations](https://www.pointfive.co/efficiency-hub/inefficiencies/excessive-snowflake-cloud-services-consumption-from-metadata-heavy-operations) The Snowflake cloud services layer handles authentication, metadata management, query compilation and optimization, and request caching. Its usage is free only up to 10% of the account's daily virtual warehouse usage; anything above that... Compute - 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 Virtual Warehouse CER-0168 ### [Underutilized Snowflake Warehouse](https://www.pointfive.co/efficiency-hub/inefficiencies/underutilized-snowflake-warehouse) Underutilized Snowflake warehouses occur when a workload is assigned a larger warehouse size than necessary. For example, a workload that could efficiently execute on a Medium (M) warehouse may be running on a Large (L) or Extra Large (XL)... Compute --- Source: the public page above. Product screenshots and illustrative interfaces are examples, not live customer data.