SyntaxPilot
Courses/SQL and Databases/Lesson 65
Video coming soonThis lesson’s video is being made

Start with the notes below; the video appears here as soon as it is on YouTube.

SQL and Databases · Lesson 65 of 90

Join algorithms and physical operators

logical vs physical operatornested loop joinindex nested loop joinhash joinbuild and probe phasesmerge joinsort-merge joinjoin ordersort operatorUSE TEMP B-TREEexternal merge sortwork_memhash aggregate vs sorted aggregate

Detailed notes for this lesson are being written. They appear here together with the video.