SQL optimization

<- Back to all Fireblog posts

Firebolt December Release Roundup: Versions 4.9 to 4.11 → Geospatial data, zero-copy cloning, and metadata operations

Firebolt delivers zero-copy cloning, a preview for processing geospatial data, and more this month.

Cole Bowden

Vector Databases Won’t Replace SQL - Andy Pavlo

Andy Pavlo, Associate Professor at Carnegie Mellon University, delves into database internals and optimization.

Firebolt Team

5 steps to debug your complex SQL queries in Firebolt

Let us guide you through the process of identifying the performance bottlenecks in your query in just 5 simple steps.

Matan Sarig
Roy Hegdish

Postgres and MySQL for Analytics - Meeting the 1 second SLA

Learn when to use Postgres, MySQL, in-memory databases, HTAP, or data warehouses to meet the 1 sec SLA in analytics.

Robert Meyer

Top 10 Ways to Improve Cloud Data Warehouse Performance (And how it’s done in Firebolt)

Lear the top 10 tips of how to improve your cloud data warehouse performance.

Robert Meyer

Snowflake vs Databricks vs Firebolt

More and more, people are asking me “how do you compare Snowflake and Databricks?” We did our best to answer.

Robert Meyer

How to accelerate Looker performance on Redshift, Snowflake and BigQuery

How to accelerate Looker performance on Redshift, Snowflake and BigQuery? Short-term fixes and the long-term solutions.

Robert Meyer

How to upgrade from Tableau extracts to a fast Tableau live connection

Learn how to upgrade from Tableau extracts to Tableau live connection to deliver sub-seconds performance every time.

Robert Meyer