Skip to content

sql: add statement hint and builtin for plan pinning using PlanGram #170692

Open
Feature
Open
sql: add statement hint and builtin for plan pinning using PlanGram#170692
Feature
Labels
A-plan-managementA-statement-hintStatement hints applied to queries externally from the statement_hints table.C-enhancementSolution expected to add code/behavior + preserve backward-compat (pg compat issues are exception)T-sql-queriesSQL Queries Team
@michae2

Description

@michae2
michae2
opened on May 20, 2026

Similar to #170360, we should add a statement hint and a builtin (or extend the ones added for #170360) to support plan pinning using PlanGrams instead of plan gists. This will allow us to better test PlanGram matching in the optimizer.

Jira issue: CRDB-64121

Metadata

Metadata

Assignees

No one assigned

    Labels

    A-plan-managementA-statement-hintStatement hints applied to queries externally from the statement_hints table.C-enhancementSolution expected to add code/behavior + preserve backward-compat (pg compat issues are exception)T-sql-queriesSQL Queries Team

    Type

    Feature

    Fields

    No fields configured for Feature.

    Projects

    SQL Queries

    Status

    Triage

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions