Optimization Hub
No matches. Try another search.

AWS Redshift · Beginner
Amazon Redshift

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

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

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

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

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

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

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

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

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

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

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

Snowflake · Beginner
Snowflake
Speed Snowflake by right-sizing and MCWs, exploiting result cache with stable SQL, modeling credit..
AWS Athena · Beginner
AWS Athena
Reduce Athena costs by enforcing result reuse, setting workgroup limits, partition projection, co...

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