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

Unlock this course with a free trial

Join today to access over 25,600 courses taught by industry experts.

Challenge: Designing a join

Challenge: Designing a join - SQL Tutorial

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

Start my 1-month free trial Buy for my team

Challenge: Designing a join

“

(upbeat music) - [Instructor] In this challenge, we want to consider which join method would be used in a particular scenario. In this case, we have an application that needs to join two large tables. Now the results of the query should be returned in sort order. What join method will likely be used?

Contents