cockroachdb / cockroachdb/cockroach

opt: add hint for skipping partial index implication

Open
#122,461 1 comment 0 reactions 0 assignees View on GitHub
C-enhancement T-sql-queries
Dominant language
Go
Stars
32.5k
Forks
4.1k
PR merge metrics
PR metrics pending

Description

The partial index implicator makes a best-effort attempt to prove that a filter implies a partial index predicate. But it is not designed to prove implication 100% of the time—doing so would be too expensive. Therefore, it may be useful to have a hint or session setting that allows partial index implication to be skipped for a specific index such that a constrained scan is always planned on it. This setting can be dangerous—using it incorrectly would produce incorrect query results—so it should be left undocumented.

Jira issue: CRDB-37897

Contributor guide

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.