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

Unlock this course with a free trial

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

Solution: Designing a join

Solution: 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

Solution: Designing a join

“

(playful music) - [Instructor] In this case, a merge join will likely be used. Joining two large tables are not good candidates for nested loop joins, but a merge join produces results in sort order. So it makes it the most likely candidate to be used in terms of a join solution.

Contents