cockroachdb / cockroachdb/cockroach
opt: use partial index implicator to remove trivial filters
Open
C-enhancement
T-sql-queries
- Dominant language
- Go
- Stars
- 32.5k
- Forks
- 4.1k
- PR merge metrics
- PR metrics pending
Description
We introduced a rule to eliminate filters that are implied by a table's check constraints in #114790. Currently, that rule uses the `Constraint.Contains` method, and only if the check constraints are tight. We may be able to match more cases by using the partial index implicator's more expansive logic.
Jira issue: CRDB-36189
Contributor guide
Assessment
This issue has not been assessed yet.