Optimization Hub

AWS Redshift · Beginner

Amazon Redshift

Oct 6, 2026

ClickHouse · Beginner

ClickHouse

Includes materialized views, intelligent sampling and dictionary lookups, optimized batch sizes...

Jun 11, 2026

Databricks · Beginner

Databricks

Includes auto-scaling warehouses, optimizing Delta layout, cluster pools, right-sized spot cluster..

Jun 11, 2026

Databricks · Advanced

Databricks

Z-ordering, Delta Cache, broadcast joins, AQE, Auto Loader, CDF, auto compaction, serverless SQL.

Jun 11, 2026

AWS Athena · Advanced

AWS Athena

Parquet partitioning, result caching, smart JOINs, compaction, approximate functions, Unload, more.

Jun 11, 2026

AWS Redshift · Advanced

Amazon Redshift

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

Jun 11, 2026

BigQuery · Beginner

BigQuery

Includes materialized views, smart partitioning, result caching, sampling, query guards, autoscali.

Jun 11, 2026

BigQuery · Advanced

BigQuery

BigQuery clustering, partitioning, materialized views, BI Engine, slot reservations, anti-patterns.

Jun 11, 2026

ClickHouse · Advanced

ClickHouse

Primary keys, skip indices, materialized views, projections, codecs, dictionary, prewhere, and more.

Jun 11, 2026

Microsoft Fabric · Advanced

Microsoft Fabric

Optimize Fabric: monitor yardsticks, Power BI aggregations, Delta layout, materialization, caching..

Jun 11, 2026

Microsoft Fabric · Advanced

Microsoft Fabric

Fabric V-ORDER, OneLake shortcuts, Direct Lake, Eventstream, KQL Database, CU optimization, more.

Jun 11, 2026

Trino · Advanced

Trino

Connector pushdown, join optimization, partitioning, caching, mem management, fault tolerance, more.

Jun 11, 2026

Snowflake · Beginner

Snowflake

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

Jun 11, 2026

AWS Athena · Beginner

AWS Athena

Reduce Athena costs by enforcing result reuse, setting workgroup limits, partition projection, co...

Aug 14, 2025

Snowflake · Beginner

Snowflake

Reduce Snowflake costs by throttling dashboard refreshes, leveraging 24-hour result cache with st..

Aug 14, 2025