--- title: Amazon Redshift increases performance for new queries in... description: Amazon Redshift now speeds up new queries by up to 7x through a new query compilation optimization called composition. This technique generates a lightweight... canonical: https://daily.dev/posts/amazon-redshift-increases-performance-for-new-queries-in-dashboards-and-etl-workloads-by-up-to-7x-cbjouwyn5 twitter:card: summary_large_image twitter:site: @dailydotdev og:type: website og:site_name: daily.dev og:title: Amazon Redshift increases performance for new queries in dashboards and ETL workloads by up to 7x | daily.dev og:description: Amazon Redshift now speeds up new queries by up to 7x through a new query compilation optimization called composition. This technique generates a lightweight... og:url: https://daily.dev/posts/amazon-redshift-increases-performance-for-new-queries-in-dashboards-and-etl-workloads-by-up-to-7x-cbjouwyn5 og:image: https://api.daily.dev/og/posts/CbJoUWyN5.png og:image:alt: Amazon Redshift increases performance for new queries in dashboards and ETL workloads by up to 7x og:image:width: 1200 og:image:height: 630 og:locale: en --- > ## Documentation Index > Fetch the complete documentation index at: https://daily.dev/llms.txt > Use this file to discover all available pages before exploring further. # Amazon Redshift increases performance for new queries in dashboards and ETL workloads by up to 7x **[AWS](https://daily.dev/sources/aws)** · 2 min read · 0 upvotes · 0 comments ## Summary Amazon Redshift now speeds up new queries by up to 7x through a new query compilation optimization called composition. This technique generates a lightweight arrangement of pre-existing logic while simultaneously compiling optimized query-specific code in the background, removing compilation from the critical path of execution. The result is faster query start times and improved response times for BI dashboards, ETL pipelines, near real-time analytics, and AI agent workloads. The improvement is automatically enabled by default across all provisioned clusters and serverless workgroups in all commercial AWS Regions at no additional cost, available on the Redshift current track. ## Full article daily.dev links to this article rather than hosting it. Read it at the original source: ## Similar posts on daily.dev - [Amazon Redshift Serverless AI-driven scaling is now the default for new workgroups](https://daily.dev/posts/amazon-redshift-serverless-ai-driven-scaling-is-now-the-default-for-new-workgroups-fgoj2vljq) · AWS · 0 upvotes · 0 comments --- Tags: [#aws](https://daily.dev/tags/aws), [#etl](https://daily.dev/tags/etl), [#data-warehouse](https://daily.dev/tags/data-warehouse) [View this post on daily.dev](https://daily.dev/posts/amazon-redshift-increases-performance-for-new-queries-in-dashboards-and-etl-workloads-by-up-to-7x-cbjouwyn5) ```json {"@context":"https://schema.org","@graph":[{"@type":"Organization","@id":"https://daily.dev/#organization","name":"daily.dev","url":"https://daily.dev","logo":{"@type":"ImageObject","url":"https://daily.dev/apple-touch-icon.png","width":180,"height":180},"sameAs":["https://twitter.com/dailydotdev","https://github.com/dailydotdev","https://www.linkedin.com/company/daily-dev-ltd"]},{"@type":"WebSite","@id":"https://daily.dev/#website","url":"https://daily.dev","name":"daily.dev","publisher":{"@id":"https://daily.dev/#organization"},"potentialAction":{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https://daily.dev/search?q={search_term_string}"},"query-input":"required name=search_term_string"}}]} {"@context":"https://schema.org","@type":"TechArticle","headline":"Amazon Redshift increases performance for new queries in dashboards and ETL workloads by up to 7x","url":"https://daily.dev/posts/amazon-redshift-increases-performance-for-new-queries-in-dashboards-and-etl-workloads-by-up-to-7x-cbjouwyn5","mainEntityOfPage":{"@type":"WebPage","@id":"https://daily.dev/posts/amazon-redshift-increases-performance-for-new-queries-in-dashboards-and-etl-workloads-by-up-to-7x-cbjouwyn5"},"datePublished":"2026-03-18T16:07:17.881Z","dateModified":"2026-03-18T16:07:37.584Z","description":"Amazon Redshift now speeds up new queries by up to 7x through a new query compilation optimization called composition. This technique generates a lightweight...","image":"https://media.daily.dev/image/upload/s--ZrL_HSsR--/f_auto/v1722860399/public/Placeholder%2006","thumbnailUrl":"https://media.daily.dev/image/upload/s--ZrL_HSsR--/f_auto/v1722860399/public/Placeholder%2006","isAccessibleForFree":true,"articleSection":"AWS","inLanguage":"en","publisher":{"@type":"Organization","name":"daily.dev","url":"https://daily.dev","logo":{"@type":"ImageObject","url":"https://daily.dev/apple-touch-icon.png","width":180,"height":180}},"author":{"@type":"Organization","name":"AWS","logo":"https://media.daily.dev/image/upload/t_logo,f_auto/v1/logos/aws","url":"https://daily.dev/sources/aws"},"commentCount":0,"discussionUrl":"https://daily.dev/posts/amazon-redshift-increases-performance-for-new-queries-in-dashboards-and-etl-workloads-by-up-to-7x-cbjouwyn5","interactionStatistic":[{"@type":"InteractionCounter","interactionType":{"@type":"LikeAction"},"userInteractionCount":0},{"@type":"InteractionCounter","interactionType":{"@type":"CommentAction"},"userInteractionCount":0}],"keywords":"aws,etl,data-warehouse","timeRequired":"PT2M"} {"@context":"https://schema.org","@type":"BreadcrumbList","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https://daily.dev"},{"@type":"ListItem","position":2,"name":"AWS","item":"https://daily.dev/sources/aws"},{"@type":"ListItem","position":3,"name":"Amazon Redshift increases performance for new queries in dashboards and ETL workloads by up to 7x"}]} ```