Get exposed to the most common techniques for improving query speed and database performance. Learn how to optimize queries by modifying SQL. Understand how indexes work and when to apply them. Learn the basics of data modeling and how it impacts performance. Understand the optimization techniques available in modern data warehouses.
What is a Query Plan
Query Plan's are the code that SQL runs on your database. Learn how the query plan works and how to optimize your SQL queries. Learn more
Order of a SQL Query
Learn the order of the SQL query to understand where you can optimize a query. Learn to prioritize FROM, JOIN, and WHERE.
Optimize your SQL Query
Learn quick tips for how to optimize your SQL queries
Optimization with EXPLAIN ANALYZE
The EXPLAIN shows the query plan for SQL queries in Postgres. Learn how to interpret the results from EXPLAIN and use it to optimize your SQL queries.
Indexing is a critical part of database optimization. Indexing can dramatically increase query speed. See how indexes work and learn to build indexes with SQL.
Partial indexes are an advanced database optimization technique. Learn how to create Partial Indexes and measure their performance.
This article walks through what multicolumn indexes are, how to make them, and when to use them.
Column and Table Optimizations
Start Modeling Data
Quick introduction on using to dbt and BigQuery to model data. Modeling data can have significance performance impacts on your database.
Schedule data modeling tasks to make data easy to query. Learn to use dbt Cloud to model data to optimize your data warehouse. Learn more.
SQL VIEWs allow you to create temporary or permanent references to data. This is a common database optimization technique. Learn more.
Learn how Redshift manages optimization for your cloud data warehouse. Learn when to manually tune the database further for more performance for SQL queries.
Learn how BigQuery optimizes your database through specific hardware optimization strategies.
Snowflake is a powerful cloud database. Learn how it optimizes your database automatically, and hot to increase performance manually.