Database management systems notes

Physical Operators

Scans, the three join algorithms, sorting and aggregation, what the plan nodes actually do. Every section is a drawn page beside a clear written explanation, about 21 minutes in all.

  • Chapter 24 of 34
  • About 21 minutes
  • 6 sections
Sign in to open it See plans

Sign in with Google or GitHub and you land straight on this page. DSA comes with the all labs plan and every ChaiCode batch.

The first drawn page of Physical Operators: The ways to read a table
The chapter's first page: The ways to read a table

In this chapter

  • The ways to read a table
  • Nested loop join
  • Hash join
  • Merge join
  • Sorting and aggregation
  • Parallel plans

Next chapters

Read the whole chapter

Sign in and the chapter opens with every drawn page, and all 35 database management systems chapters beside it.

Sign in to open itSee plans

DSA comes with the all labs plan and every ChaiCode batch.