Skip to content

sql: setting to disable NotVisible index feature #14819

@cockroach-teamcity

Description

@cockroach-teamcity

Exalate commented:

Related PR: cockroachdb/cockroach#86033
Commit: cockroachdb/cockroach@5830d70


Release note (sql change): Session setting optimizer_use_not_visible_indexes
and cluster setting sql.defaults.optimizer_use_not_visible_indexes.enabled can
be used to disable not visible index feature. When they are enabled, optimizer
treats not visible indexes as they are visible and can choose to use them for
query plan. By default, they are disabled.

Jira Issue: DOC-5345

Metadata

Metadata

Assignees

No one assigned

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions