Skip to content

Add primary keys to TPC-H, TPC-DS schemas #22595

Description

@neilconway

Is your feature request related to a problem or challenge?

These constraints can be used by the optimizer to generate better plans (e.g., by leveraging FDs). The constraints are defined by the TPC specs, and including them makes the benchmark environment closer to a realistic TPC-H/DS benchmark run.

Describe the solution you'd like

No response

Describe alternatives you've considered

No response

Additional context

No response

Activity

  1. neilconway commented on May 28, 2026

    @neilconway
    ContributorAuthor

    take

  2. changed the title [-]Add PKs, unique constraints to TPC-H, TPC-DS schemas[/-] [+]Add PK to TPC-H, TPC-DS schemas[/+] on May 30, 2026
  3. changed the title [-]Add PK to TPC-H, TPC-DS schemas[/-] [+]Add PKs to TPC-H, TPC-DS schemas[/+] on May 30, 2026
  4. changed the title [-]Add PKs to TPC-H, TPC-DS schemas[/-] [+]Add primary keys to TPC-H, TPC-DS schemas[/+] on May 30, 2026
  5. added a commit that references this issue on Jun 1, 2026
    73e3c2a
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Metadata

Metadata

Assignees

Labels

enhancementNew feature or request

Projects

No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions