|< < 4 > >|

Duplicates

Real world

  • Duplicate detection can be expensive.

  • Only eliminate duplicates when it is cheap.

    Tables with a primary key

    The primary key guarantees uniqueness, so the table is a set.

    Tables without a primary key (or uniqueness constraint)

    Allows duplicates.

    Scripts: See duplicates.sql.

    • |< < 4 > >|