# Databricks SQL optimization | Cloud Efficiency Hub

Canonical: https://www.pointfive.co/efficiency-hub/cloud-services/databricks-sql

4 documented Databricks SQL cost inefficiencies, each with how to detect it and how to fix it.

[Cloud Efficiency Hub](https://www.pointfive.co/efficiency-hub) 

4 documented Databricks SQL cost inefficiencies, each with how to detect it and how to fix it.

## 4 inefficiencies

[All services](https://www.pointfive.co/efficiency-hub#browse-by-service)

- Databricks SQL  CER-0225

### [Underuse of Serverless for Short or Interactive Workloads](https://www.pointfive.co/efficiency-hub/inefficiencies/underuse-of-serverless-for-short-or-interactive-workloads)

Many organizations continue running short-lived or low-intensity SQL workloads - such as dashboards, exploratory queries, and BI tool integrations - on traditional clusters. This leads to idle compute, overprovisioning, and high baseline...

Compute

- Databricks SQL  CER-0220

### [Inefficient Query Design in Databricks SQL and Spark Jobs](https://www.pointfive.co/efficiency-hub/inefficiencies/inefficient-query-design-in-databricks-sql-and-spark-jobs)

Many Spark and SQL workloads in Databricks suffer from micro-optimization issues - such as unfiltered joins, unnecessary shuffles, missing broadcast joins, and repeated scans of uncached data. These problems increase compute time and...

Compute

- Databricks SQL  CER-0521

### [Oversized Databricks SQL Warehouses](https://www.pointfive.co/efficiency-hub/inefficiencies/oversized-databricks-sql-warehouses)

A Databricks SQL warehouse's cluster size sets the driver instance and the number of workers in each of its clusters, from 2X-Small with one worker up to 5X-Large with 512, doubling at each step. The warehouse bills for that size for every...

Compute

- Databricks SQL  CER-0522

### [Long or Disabled Auto Stop on Databricks SQL Warehouses](https://www.pointfive.co/efficiency-hub/inefficiencies/long-or-disabled-auto-stop-on-databricks-sql-warehouses)

A Databricks SQL warehouse keeps running after its last query until its Auto Stop timer expires, and Databricks states that idle SQL warehouses continue to accumulate DBU and cloud instance charges until they are stopped. For typical use...

Compute

## More Databricks services

- [Databricks Clusters  7](https://www.pointfive.co/efficiency-hub/cloud-services/databricks-clusters)

- [Databricks Compute  5](https://www.pointfive.co/efficiency-hub/cloud-services/databricks-compute)

- [Databricks  3](https://www.pointfive.co/efficiency-hub/cloud-services/databricks)

- [Databricks Serverless Compute  2](https://www.pointfive.co/efficiency-hub/cloud-services/databricks-serverless-compute)

- [Databricks Workflows  2](https://www.pointfive.co/efficiency-hub/cloud-services/databricks-workflows)

- [Delta Lake  2](https://www.pointfive.co/efficiency-hub/cloud-services/delta-lake)

- [Interactive Clusters  1](https://www.pointfive.co/efficiency-hub/cloud-services/interactive-clusters)

- [Databricks Model Serving  1](https://www.pointfive.co/efficiency-hub/cloud-services/databricks-model-serving)

- [Databricks AI Search  1](https://www.pointfive.co/efficiency-hub/cloud-services/databricks-ai-search)

- [Databricks Lakeflow Pipelines  1](https://www.pointfive.co/efficiency-hub/cloud-services/databricks-lakeflow-pipelines)

---
Source: the public page above. Product screenshots and illustrative interfaces are examples, not live customer data.