Sign inSign in
ConceptSystems & CS

Suffix truncation

Comparing a binary prefix of long VARCHAR keys as a surrogate before falling back to slower string comparison.
as Jignesh Patel defines itCarnegie Mellon University
Watch it explained

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.

Binary encoding1Index traversal1Inner nodes1String comparison1

Lecturers

2

Each in their own terms, from the easiest level.

  • Andy Pavlo

    Carnegie Mellon University · Undergraduate

    Storing only the minimum prefix needed in inner nodes to route probes correctly since inner nodes only direct traffic.

Connections

4

The lectures that define it or assume it, and the concepts next to it.

Concepts2

Lectures2

2 lecturers. Definitions are written by AI from each lecture’s transcript. A time with a play mark starts the lecture at the moment the lecturer says it.