ConceptSystems & CS
Sequential scan
Scanning through large chunks of data sequentially without using index lookups.
Know first
Named as a prerequisite by the lectures that define this. The number is how many say so. A grey one has no page yet.
Opens up
Concepts that name this one as a prerequisite.
Lecturers
2Each in their own terms, from the easiest level.
Andy Pavlo
Jignesh Patel
A sequential scan retrieves pages from the buffer pool and iterates over each tuple to check whether to include it, maintaining an internal cursor.
Lectures that assume it
3Connections
13The lectures that define it or assume it, and the concepts next to it.