From the course: Advanced SQL for Query Tuning and Performance Optimization

Reduce query response time with query tuning - SQL Tutorial

From the course: Advanced SQL for Query Tuning and Performance Optimization

Start my 1-month free trial Buy for my team

Reduce query response time with query tuning

“

- [Dan] No one likes waiting for a slow-running query. The good news is that in many cases, you can speed up those queries. Understanding how databases translate SQL queries into execution plans will help you optimize queries. In this course, you'll learn how SQL queries are executed, how to use different kinds of indexes to improve performance, why the query plan builder chooses a particular join method, and how to use partitioning and materialized views to reduce query response time. With a solid understanding of how SQL queries are executed, you'll know how to tune your database schemas and queries to give you the performance you need. My name is Dan Sullivan. I'm an architect, and I work on large-scale data-intensive applications. So let's dive into "Advanced SQL for Query Tuning and Performance Optimization" so you can tune your SQL queries for their optimal performance.

Contents