Query and Cost Optimisation

Cost and Query Optimization Guides for Modern Data Workloads

A comprehensive guide for data engineers to optimise their data compute cost and performance at scale

Filter by

Engine type
Optimization Types
Optimization Level
Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.

ClickHouse

Query Optimization
Primary keys, skip indices, materialized views, projections, codecs, dictionary, prewhere, and more.
Read more
Advanced
ClickHouse

AWS Athena

Query Optimization
Parquet partitioning, result caching, smart JOINs, compaction, approximate functions, Unload, more.
Read more
Advanced
AWS Athena

Trino

Query Optimization
Connector pushdown, join optimization, partitioning, caching, mem management, fault tolerance, more.
Read more
Advanced
Trino

BigQuery

Query Optimization
BigQuery clustering, partitioning, materialized views, BI Engine, slot reservations, anti-patterns.
Read more
Advanced
BigQuery

Microsoft Fabric

Query Optimization
Fabric V-ORDER, OneLake shortcuts, Direct Lake, Eventstream, KQL Database, CU optimization, more.
Read more
Advanced
Microsoft Fabric

Amazon Redshift

Query Optimization
15 AWS Redshift optimization techniques: distribution keys, materialized views, WLM, caching & more.
Read more
Advanced
AWS Redshift

Databricks

Query Optimization
Z-ordering, Delta Cache, broadcast joins, AQE, Auto Loader, CDF, auto compaction, serverless SQL.
Read more
Advanced
Databricks

BigQuery

Cost Optimization
Includes materialized views, smart partitioning, result caching, sampling, query guards, autoscali..
Read more
Beginner
BigQuery

Microsoft Fabric

Cost Optimization
Optimize Fabric: monitor yardsticks, Power BI aggregations, Delta layout, materialization, caching..
Read more
Advanced
Microsoft Fabric

Databricks

Cost Optimization
Includes auto-scaling warehouses, optimizing Delta layout, cluster pools, right-sized spot cluster..
Read more
Beginner
Databricks

ClickHouse

Cost Optimization
Includes materialized views, intelligent sampling and dictionary lookups, optimized batch sizes...
Read more
Beginner
ClickHouse

Snowflake

Query Optimization
Speed Snowflake by right-sizing and MCWs, exploiting result cache with stable SQL, modeling credit..
Read more
Snowflake

AWS Athena

Cost Optimization
Reduce Athena costs by enforcing result reuse, setting workgroup limits, partition projection, co...
Read more
AWS Athena

Snowflake

Cost Optimization
Reduce Snowflake costs by throttling dashboard refreshes, leveraging 24-hour result cache with st..
Read more
Beginner
Snowflake
This optimisation hub is coming soon
Available at
BlogEventsDocs
Terms and ConditionsPrivacy PolicyCookie Policy
© 2025 e6data Inc. All rights reserved.