Skip to content

Support plan cache for partial index on limit cases for the constraint col is not null #64346

@winoros

Description

@winoros

Enhancement

We only support the plan cache for very limited cases:

  • The constraint of the partial index is column is not null
  • The given SQL must have the compare operators >\<\>=\<=\=(nulleq is excluded because it can accept null value) on the constraint column.

Metadata

Metadata

Assignees

No one assigned

    Labels

    sig/plannerSIG: Plannertype/enhancementThe issue or PR belongs to an enhancement.

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions