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